eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_INV_CPCS_PKG dependencies on ORG_ACCT_PERIODS

Line 275: org_acct_periods oap

271: g_created_by created_by,
272: g_last_updated_by last_updated_by,
273: g_last_update_login last_update_login
274: FROM cst_period_close_summary cpcs,
275: org_acct_periods oap
276: WHERE cpcs.acct_period_id = oap.acct_period_id
277: AND cpcs.organization_id = oap.organization_id
278: AND oap.schedule_close_date >= g_global_start_date
279: AND oap.summarized_flag ='Y'

Line 420: org_acct_periods oap,

416: sum(rollback_onhand_value) cpcs_onhand_value_b,
417: sum(rollback_intransit_value) cpcs_intransit_value_b
418: FROM
419: cst_period_close_summary cpcs,
420: org_acct_periods oap,
421: opi_dbi_inv_value_log invlog
422: WHERE cpcs.acct_period_id = oap.acct_period_id
423: AND cpcs.organization_id = oap.organization_id
424: AND oap.summarized_flag ='Y'

Line 517: org_acct_periods oap,

513: g_last_updated_by last_updated_by,
514: g_last_update_login last_update_login
515: FROM
516: cst_period_close_summary cpcs,
517: org_acct_periods oap,
518: OPI_DBI_INV_VALUE_LOG invlog
519: WHERE
520: cpcs.acct_period_id = oap.acct_period_id
521: AND cpcs.organization_id = oap.organization_id

Line 638: org_acct_periods oap,

634: g_last_updated_by last_updated_by,
635: g_last_update_login last_update_login
636: FROM
637: cst_period_close_summary cpcs,
638: org_acct_periods oap,
639: opi_dbi_inv_value_log invlog
640: WHERE cpcs.acct_period_id = oap.acct_period_id
641: AND cpcs.organization_id = oap.organization_id
642: AND oap.summarized_flag ='Y'