月结各模块关闭情况查询SQL代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】月结各模块关闭情况查询SQL

作者:dezai / 发布于2014/1/26/ 945

月结各模块关闭情况查询SQL

-----库存模块
SELECT oap.STATUS 关闭状态,
   oap.PERIOD_NAME 所属期间,
   oap.ORGANIZATION_ID 组织ID,
   (select name from hr_organization_units x where x.ORGANIZATION_ID = oap.ORGANIZATION_ID) 组织名称,
   oap.LAST_UPDATE_DATE 执行关闭日期,
   (select hre.full_name from hr_employees_all_v hre,fnd_user fu where hre.employee_id = fu.employee_id and fu.user_id = oap.LAST_UPDATED_BY) 执行关闭人,
   oap.CREATED_BY
 FROM ORG_ACCT_PERIODS_V oap
WHERE
 (oap.PERIOD_NUMBER = 6)      --月份
 and (oap.PERIOD_YEAR = 2012)    -- 年份
 and oap.ORGANIZATION_ID <> 0
order by oap.ORGANIZATION_ID,oap.PERIOD_NAME desc,oap.Status desc
-----------------------------------------------------------------其他模块------------------------------------------------------------
SELECT gps.PERIOD_NAME 所属期间,
   (select faa.Application_name
     from fnd_application_all_view faa
    where faa.APPLICATION_ID = gps.APPLICATION_ID) 模块名称,
   gps.LEDGER_ID 分类账套,
   gps.SHOW_STATUS 期间状态,
   (select hre.full_name from hr_employees_all_v hre,fnd_user fu where hre.employee_id = fu.employee_id and fu.user_id = gps.LAST_UPDATED_BY) 执行关闭人,
   gps.LAST_UPDATE_DATE 最后次操作时间
 FROM GL_PERIOD_STATUSES_V gps
WHERE --gps.application_id = 101
 --AND
 
 gps.ledger_id = 2021
 AND gps.closing_status != 'N'
 and (gps.LEDGER_ID = 2021)
order by gps.APPLICATION_ID,gps.PERIOD_NAME desc

试试其它关键字

同语言下

可能有用的

dezai贡献的其它代码(1065)