APPS.AHL_SB_RULES_PVT dependencies on CSI_II_RELATIONSHIPS

Line 149: CSI_II_RELATIONSHIPS CSR

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
153: AND CSI.inv_master_organization_id = IAB.inventory_org_id

Line 406: FROM CSI_II_RELATIONSHIPS

402: WHERE UE.mr_header_id = SB2.mr_header_id
403: AND UE.csi_item_instance_id = UC.csi_item_instance_id
404: AND UE.accomplished_date IS NOT NULL))
405: AND EXISTS (SELECT 'X'
406: FROM CSI_II_RELATIONSHIPS
407: WHERE subject_id = c_instance_id -- SB rules are created for non-root positions
408: AND TO_NUMBER(position_reference) = SB.relationship_id
409: AND relationship_type_code = 'COMPONENT-OF'
410: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE))

Line 1713: CSI_II_RELATIONSHIPS CSR

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
1717: AND CSI.inv_master_organization_id = IAB.inventory_org_id

Line 1728: FROM CSI_II_RELATIONSHIPS

1724: -- cursor to get the instance id for a given unit and relationship
1725: CURSOR get_instance_id_csr (c_uc_header_id NUMBER,
1726: c_relationship_id NUMBER) IS
1727: SELECT subject_id
1728: FROM CSI_II_RELATIONSHIPS
1729: WHERE position_reference = TO_CHAR(c_relationship_id)
1730: AND relationship_type_code = 'COMPONENT-OF'
1731: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
1732: AND AHL_UTIL_UC_PKG.get_sub_uc_header_id(object_id) = c_uc_header_id; -- SB rules are created for non-root positions