APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_HEADERS_B

Line 195: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC

191: -- SURRKUMA :: Service Bulletin :: 07-Jun-2011
192: -- Modified the cursor to fetch UC header id too, for getting the affected SB rule later
193: CURSOR get_mc_dtls_csr(c_instance_id IN NUMBER) IS
194: select UC.MASTER_CONFIG_ID, MC.MC_ID, MC.VERSION_NUMBER,UC.UNIT_CONFIG_HEADER_ID
195: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC
196: where UC.CSI_ITEM_INSTANCE_ID = c_instance_id AND
197: MC.MC_HEADER_ID = UC.MASTER_CONFIG_ID;
198:
199: CURSOR get_item_from_instance_csr(c_instance_id IN NUMBER) IS

Line 922: FROM AHL_MC_CONFIG_RELATIONS CR, AHL_MC_HEADERS_B MC

918: AND parent_relationship_id is null;
919:
920: CURSOR get_sub_mc_for_pos_csr(c_position_id IN NUMBER) IS
921: SELECT CR.mc_header_id
922: FROM AHL_MC_CONFIG_RELATIONS CR, AHL_MC_HEADERS_B MC
923: WHERE CR.relationship_id = c_position_id
924: AND MC.mc_header_id = CR.mc_header_id
925: ORDER BY MC.name;
926:

Line 2095: ahl_mc_headers_b mch,

2091: c_quantity IN NUMBER) IS
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