eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 916: FROM AHL_MC_RELATIONSHIPS

912: WHERE CSI_ITEM_INSTANCE_ID = c_pos_instance_id;
913:
914: CURSOR get_item_grp_for_mc_csr(c_mc_header_id IN NUMBER) IS
915: SELECT item_group_id
916: FROM AHL_MC_RELATIONSHIPS
917: WHERE mc_header_id = c_mc_header_id
918: AND parent_relationship_id is null;
919:
920: CURSOR get_sub_mc_for_pos_csr(c_position_id IN NUMBER) IS

Line 1699: FROM AHL_MC_RELATIONSHIPS

1695:
1696: CURSOR get_position_dtls_csr(c_pos_key IN NUMBER,
1697: c_mc_header_id IN NUMBER) IS
1698: SELECT relationship_id, item_group_id
1699: FROM AHL_MC_RELATIONSHIPS
1700: WHERE POSITION_KEY = c_pos_key AND
1701: MC_HEADER_ID = c_mc_header_id;
1702:
1703: CURSOR get_config_dtls_csr(c_unit_instance_id IN NUMBER) IS

Line 1714: FROM AHL_MC_RELATIONSHIPS

1710: CURSOR get_all_position_dates_csr(c_start_pos_key IN NUMBER,
1711: c_mc_header_id IN NUMBER) IS
1712: SELECT ACTIVE_START_DATE,
1713: ACTIVE_END_DATE
1714: FROM AHL_MC_RELATIONSHIPS
1715: START WITH POSITION_KEY = c_start_pos_key AND
1716: MC_HEADER_ID = c_mc_header_id
1717: CONNECT BY RELATIONSHIP_ID = PRIOR PARENT_RELATIONSHIP_ID;
1718:

Line 1725: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL

1721: II.SUBJECT_ID,
1722: REL.RELATIONSHIP_ID,
1723: REL.ACTIVE_START_DATE,
1724: REL.ACTIVE_END_DATE
1725: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL
1726: WHERE NVL(II.ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1727: NVL(II.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE AND
1728: II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
1729: REL.RELATIONSHIP_ID =TO_NUMBER(II.POSITION_REFERENCE)

Line 2011: FROM ahl_mc_relationships

2007: SELECT relationship_id,
2008: item_group_id,
2009: quantity,
2010: uom_code
2011: FROM ahl_mc_relationships
2012: WHERE mc_header_id = c_mc_header_id
2013: AND position_key = c_position_key;
2014:
2015: -- cursor to get applicable SB rules for the given unit and position

Line 2072: FROM ahl_mc_relationships mcr, ahl_mc_config_relations smc

2068:
2069: -- Cursor to get allowable sub configuration item group ids for the given position
2070: CURSOR get_sub_config_item_group(c_relationship_id IN NUMBER) IS
2071: SELECT mcr.item_group_id
2072: FROM ahl_mc_relationships mcr, ahl_mc_config_relations smc
2073: WHERE mcr.mc_header_id = smc.mc_header_id
2074: AND mcr.parent_relationship_id is null
2075: AND smc.relationship_id = c_relationship_id
2076: ORDER BY smc.priority;

Line 2096: ahl_mc_relationships rel,

2092: SELECT rel.relationship_id, NVL(c_quantity, mcrs.object_attribute1)
2093: FROM ahl_mc_path_position_nodes mcpp,
2094: ahl_mc_rule_statements mcrs,
2095: ahl_mc_headers_b mch,
2096: ahl_mc_relationships rel,
2097: ahl_mc_rules_b mcr
2098: WHERE mch.mc_header_id = c_mc_header_id
2099: AND mcpp.mc_id = mch.mc_id
2100: AND mch.version_number = NVL(mcpp.version_number, mch.version_number)

Line 2119: FROM ahl_mc_relationships mcr

2115: -- Added by SURRKUMA for Service Bulletin on 26-Jul-2011
2116: -- Use the followig cursor to get the child positions of a parent position.
2117: CURSOR get_child_positions_csr(c_relationship_id IN NUMBER) IS
2118: SELECT mcr.position_key
2119: FROM ahl_mc_relationships mcr
2120: WHERE mcr.parent_relationship_id = c_relationship_id
2121: AND NVL(mcr.active_end_date, SYSDATE + 1) > SYSDATE
2122: ORDER BY display_order;
2123:

Line 2627: ahl_mc_relationships mcr,

2623: smc.priority smc_priority,
2624: ia.priority item_priority
2625: FROM ahl_item_associations_b ia,
2626: mtl_system_items_b msi,
2627: ahl_mc_relationships mcr,
2628: ahl_mc_config_relations smc
2629: WHERE mcr.mc_header_id = smc.mc_header_id
2630: AND mcr.parent_relationship_id is null
2631: AND smc.relationship_id = c_relationship_id

Line 2643: ahl_mc_relationships mcr

2639: TO_NUMBER(NULL) AS smc_priority,
2640: ia.priority item_priority
2641: FROM ahl_item_associations_b ia,
2642: mtl_system_items_b msi,
2643: ahl_mc_relationships mcr
2644: WHERE mcr.relationship_id = c_relationship_id
2645: AND ia.item_group_id = mcr.item_group_id
2646: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'
2647: AND ia.inventory_item_id = msi.inventory_item_id

Line 2663: ahl_mc_relationships mcr,

2659: smc.priority smc_priority,
2660: ia.priority item_priority
2661: FROM ahl_item_associations_b ia,
2662: mtl_system_items_b msi,
2663: ahl_mc_relationships mcr,
2664: ahl_mc_config_relations smc
2665: WHERE mcr.mc_header_id = smc.mc_header_id
2666: AND mcr.parent_relationship_id is null
2667: AND smc.relationship_id = c_relationship_id

Line 2683: ahl_mc_relationships mcr

2679: TO_NUMBER(NULL) AS smc_priority,
2680: ia.priority item_priority
2681: FROM ahl_item_associations_b ia,
2682: mtl_system_items_b msi,
2683: ahl_mc_relationships mcr
2684: WHERE mcr.relationship_id = c_relationship_id
2685: AND ia.item_group_id = mcr.item_group_id
2686: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'
2687: AND ia.inventory_item_id = msi.inventory_item_id