DBA Data[Home] [Help]

APPS.AHL_CMP_PVT dependencies on CSI_I_PARTIES

Line 2870: FROM csi_item_instances c, csi_i_parties p

2866: c.inventory_revision,
2867: p.party_id,
2868: p.party_source_table,
2869: p.instance_party_id
2870: FROM csi_item_instances c, csi_i_parties p
2871: WHERE c.instance_id = c_csi_instance_id
2872: AND p.instance_id = c.instance_id
2873: AND p.relationship_type_code = 'OWNER'
2874: AND trunc(nvl(c.active_start_date, SYSDATE)) <= trunc(SYSDATE)