APPS.INV_DIAG_UNCST dependencies on ORG_ACCT_PERIODS

Line 45: FROM org_acct_periods

41: if l_org_id is not null and l_acct_period is not null then
42: begin
43: SELECT acct_period_id
44: into l_acct_period_id
45: FROM org_acct_periods
46: WHERE organization_id = l_org_id
47: AND period_name = l_acct_period;
48: exception
49: when others then

Line 76: ' , org_acct_periods oap '||

72: ' , mmt.acct_period_id "Period Id" '||
73: ' , mmt.costed_flag "Costed Flag" '||
74: ' , COUNT(*) "Count" '||
75: 'FROM mtl_material_transactions mmt, mtl_parameters mp '||
76: ' , org_acct_periods oap '||
77: 'WHERE mmt.organization_id = mp.organization_id '||
78: ' AND mmt.acct_period_id = oap.acct_period_id(+) '||
79: ' AND costed_flag IS NOT NULL '||
80: 'GROUP BY mp.organization_code, mmt.organization_id '||

Line 98: 'FROM org_acct_periods oap '||

94: ' , TO_CHAR( oap.period_start_date,''DD-MON-RR'') "Start Date" '||
95: ' , TO_CHAR( oap.schedule_close_date,''DD-MON-RR'') "Scheduled Close Date" '||
96: ' , TO_CHAR( oap.period_close_date,''DD-MON-RR'') "Close Date" '||
97: ' , oap.open_flag "Open Flag" '||
98: 'FROM org_acct_periods oap '||
99: ' , mtl_material_transactions mmt '||
100: 'WHERE mmt.costed_flag IS NOT NULL '||
101: ' AND oap.organization_id = mmt.organization_id '||
102: ' AND (mmt.acct_period_id IS NULL OR mmt.acct_period_id=-1) '||