APPS.AHL_SB_RULES_PVT dependencies on CSI_ITEM_INSTANCES

Line 148: CSI_ITEM_INSTANCES CSI,

144: c_relationship_id NUMBER) IS
145: SELECT 'X'
146: FROM AHL_SB_RULE_ITEMS SBI,
147: AHL_ITEM_ASSOCIATIONS_B IAB,
148: CSI_ITEM_INSTANCES CSI,
149: CSI_II_RELATIONSHIPS CSR
150: WHERE SBI.rule_id = c_rule_id
151: AND IAB.item_association_id = SBI.item_association_id
152: AND CSI.inventory_item_id = IAB.inventory_item_id

Line 367: FROM CSI_ITEM_INSTANCES

363:
364: -- cursor to check the instance id
365: CURSOR chk_instance_id_csr (c_instance_id NUMBER) IS
366: SELECT 'X'
367: FROM CSI_ITEM_INSTANCES
368: WHERE instance_id = c_instance_id
369: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
370: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
371:

Line 420: CSI_ITEM_INSTANCES CSI

416: c_instance_id NUMBER) IS
417: SELECT 'X'
418: FROM AHL_SB_RULE_ITEMS SBI,
419: AHL_ITEM_ASSOCIATIONS_B IAB,
420: CSI_ITEM_INSTANCES CSI
421: WHERE SBI.rule_id = c_rule_id
422: AND IAB.item_association_id = SBI.item_association_id
423: AND CSI.inventory_item_id = IAB.inventory_item_id
424: AND CSI.inv_master_organization_id = IAB.inventory_org_id

Line 1712: CSI_ITEM_INSTANCES CSI,

1708: c_relationship_id NUMBER) IS
1709: SELECT 'X'
1710: FROM AHL_SB_RULE_ITEMS SBI,
1711: AHL_ITEM_ASSOCIATIONS_B IAB,
1712: CSI_ITEM_INSTANCES CSI,
1713: CSI_II_RELATIONSHIPS CSR
1714: WHERE SBI.rule_id = c_rule_id
1715: AND IAB.item_association_id = SBI.item_association_id
1716: AND CSI.inventory_item_id = IAB.inventory_item_id