DBA Data[Home] [Help]

APPS.JAI_RCV_OPM_COSTING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 69: FROM jai_cmn_inventory_orgs jcio,

65: WHERE ( p_organization_id IS NULL OR to_organization_id = p_organization_id )
66: /*even though to_organization_id is NULL ALLOWED, it is always populated*/
67: --AND trunc(creation_date) between cp_start_date AND cp_end_date /*bug 8830292*/
68: AND to_organization_id IN ( SELECT jcio.organization_id
69: FROM jai_cmn_inventory_orgs jcio,
70: mtl_parameters mtl
71: WHERE mtl.organization_id = jcio.organization_id
72: AND mtl.process_enabled_flag = 'Y'
73: )