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 CST_PERIOD_CLOSE_SUMMARY

Line 274: FROM cst_period_close_summary cpcs,

270: g_sysdate last_update_date,
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

Line 419: cst_period_close_summary cpcs,

415: trunc(oap.schedule_close_date) transaction_date,
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

Line 516: cst_period_close_summary cpcs,

512: g_created_by created_by,
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

Line 637: cst_period_close_summary cpcs,

633: g_created_by created_by,
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