APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 205: FROM ahl_item_associations_b

201: where INSTANCE_ID = c_instance_id;
202:
203: CURSOR get_item_group_item_csr(c_item_group_id IN NUMBER) IS
204: SELECT inventory_item_id, inventory_org_id
205: FROM ahl_item_associations_b
206: WHERE item_group_id = c_item_group_id
207: AND interchange_type_code in ('1-WAY INTERCHANGEABLE', '2-WAY INTERCHANGEABLE')
208: ORDER BY priority;
209:

Line 2445: FROM ahl_item_associations_b ia, mtl_system_items_b msi

2441: ) IS
2442: -- To Get highest priority item when SB is not present
2443: CURSOR get_item_group_item_csr IS
2444: SELECT ia.inventory_item_id, NVL(p_visit_org_id, ia.inventory_org_id), ia.quantity, ia.uom_code
2445: FROM ahl_item_associations_b ia, mtl_system_items_b msi
2446: WHERE ia.item_group_id = p_item_group_id
2447: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'
2448: AND ia.inventory_item_id = msi.inventory_item_id
2449: AND msi.organization_id = NVL(p_visit_org_id, ia.inventory_org_id)

Line 2455: FROM ahl_item_associations_b ia, mtl_system_items_b msi

2451:
2452: -- To Get the highest priority item when SB is present
2453: CURSOR get_item_group_sb_item_csr IS
2454: SELECT ia.inventory_item_id, NVL(p_visit_org_id, ia.inventory_org_id), ia.quantity, ia.uom_code
2455: FROM ahl_item_associations_b ia, mtl_system_items_b msi
2456: WHERE ia.item_group_id = p_item_group_id
2457: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'
2458: AND ia.inventory_item_id = msi.inventory_item_id
2459: AND msi.organization_id = NVL(p_visit_org_id, ia.inventory_org_id)

Line 2608: FROM ahl_item_associations_b ia,

2604: CURSOR get_alt_items_ig_csr(c_item_group_id IN NUMBER,
2605: c_inventory_item_id IN NUMBER,
2606: c_organization_id IN NUMBER) IS
2607: SELECT ia.inventory_item_id
2608: FROM ahl_item_associations_b ia,
2609: mtl_system_items_b msi
2610: WHERE ia.item_group_id = c_item_group_id
2611: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'
2612: AND ia.inventory_item_id = msi.inventory_item_id

Line 2625: FROM ahl_item_associations_b ia,

2621: c_organization_id IN NUMBER) IS
2622: SELECT ia.inventory_item_id,
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

Line 2641: FROM ahl_item_associations_b ia,

2637: UNION
2638: SELECT ia.inventory_item_id,
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

Line 2661: FROM ahl_item_associations_b ia,

2657: c_sb_rule_id IN NUMBER) IS
2658: SELECT ia.inventory_item_id,
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

Line 2681: FROM ahl_item_associations_b ia,

2677: UNION
2678: SELECT ia.inventory_item_id,
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