APPS.INV_DIAG_MMTT dependencies on ORG_ACCT_PERIODS

Line 64: FROM org_acct_periods

60: if l_org_id is not null and l_acct_period is not null then
61: begin
62: SELECT acct_period_id
63: into l_acct_period_id
64: FROM org_acct_periods
65: WHERE organization_id = l_org_id
66: AND period_name = l_acct_period;
67: exception
68: when others then

Line 117: ' , org_acct_periods oap '||

113: ' , period_set_name "GL Period Set|Name" '||
114: ' , period_name "GL Period|Name" '||
115: ' , period_year "GL Period|Year" '||
116: ' FROM mtl_material_transactions_temp mmtt, mtl_parameters mp '||
117: ' , org_acct_periods oap '||
118: ' WHERE NVL( mmtt.transaction_status,1 ) != 2 '||
119: ' AND mmtt.organization_id=mp.organization_id(+) '||
120: ' AND mmtt.acct_period_id=oap.acct_period_id(+)';
121: if l_org_id is not null then

Line 192: sqltxt :=sqltxt||' ,org_acct_periods oap ';

188: if l_org_id is null then
189: sqltxt :=sqltxt||' ,mtl_parameters mp ';
190: end if;
191: if l_acct_period_id is null then
192: sqltxt :=sqltxt||' ,org_acct_periods oap ';
193: end if;
194:
195: sqltxt := sqltxt||' WHERE NVL(transaction_status,1)!=2 '||
196: ' AND mmtt.transaction_type_id=mtt.transaction_type_id '||

Line 389: ' , org_acct_periods oap '||

385: ' , mmtt.process_flag "Process Flag" '||
386: ' , mmtt.lock_flag "Lock Flag" '||
387: ' , COUNT(*) "Count" '||
388: ' FROM mtl_material_transactions_temp mmtt, mtl_parameters mp '||
389: ' , org_acct_periods oap '||
390: 'WHERE NVL( mmtt.transaction_status,1 ) != 2 '||
391: ' AND mmtt.organization_id=mp.organization_id(+) '||
392: ' AND mmtt.acct_period_id=oap.acct_period_id(+) ';
393: if l_org_id is not null then