APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 859: FROM AHL_MC_RELATIONSHIPS

855: WHERE CSI_ITEM_INSTANCE_ID = c_pos_instance_id;
856:
857: CURSOR get_item_grp_for_mc_csr(c_mc_header_id IN NUMBER) IS
858: SELECT item_group_id
859: FROM AHL_MC_RELATIONSHIPS
860: WHERE mc_header_id = c_mc_header_id
861: AND parent_relationship_id is null;
862:
863: CURSOR get_sub_mc_for_pos_csr(c_position_id IN NUMBER) IS

Line 1423: FROM AHL_MC_RELATIONSHIPS

1419:
1420: CURSOR get_position_dtls_csr(c_pos_key IN NUMBER,
1421: c_mc_header_id IN NUMBER) IS
1422: SELECT relationship_id, item_group_id
1423: FROM AHL_MC_RELATIONSHIPS
1424: WHERE POSITION_KEY = c_pos_key AND
1425: MC_HEADER_ID = c_mc_header_id;
1426:
1427: CURSOR get_config_dtls_csr(c_unit_instance_id IN NUMBER) IS

Line 1438: FROM AHL_MC_RELATIONSHIPS

1434: CURSOR get_all_position_dates_csr(c_start_pos_key IN NUMBER,
1435: c_mc_header_id IN NUMBER) IS
1436: SELECT ACTIVE_START_DATE,
1437: ACTIVE_END_DATE
1438: FROM AHL_MC_RELATIONSHIPS
1439: START WITH POSITION_KEY = c_start_pos_key AND
1440: MC_HEADER_ID = c_mc_header_id
1441: CONNECT BY RELATIONSHIP_ID = PRIOR PARENT_RELATIONSHIP_ID;
1442:

Line 1449: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL

1445: II.SUBJECT_ID,
1446: REL.RELATIONSHIP_ID,
1447: REL.ACTIVE_START_DATE,
1448: REL.ACTIVE_END_DATE
1449: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL
1450: WHERE NVL(II.ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1451: NVL(II.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE AND
1452: II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
1453: REL.RELATIONSHIP_ID =TO_NUMBER(II.POSITION_REFERENCE)