APPS.AHL_LTP_MTL_REQ_PVT dependencies on MTL_SYSTEM_ITEMS

Line 448: select primary_uom_code from mtl_system_items

444: p_source_uom_code IN VARCHAR2,
445: p_quantity IN NUMBER) RETURN NUMBER IS
446:
447: CURSOR get_primary_uom_csr IS
448: select primary_uom_code from mtl_system_items
449: where inventory_item_id = p_inventory_item_id;
450:
451: l_primary_uom VARCHAR2(10);
452: l_converted_qty NUMBER;

Line 513: select primary_uom_code from mtl_system_items

509: p_inventory_item_id IN NUMBER,
510: p_inventory_org_id IN NUMBER
511: ) RETURN VARCHAR2 IS
512: CURSOR get_primary_uom_csr IS
513: select primary_uom_code from mtl_system_items
514: where inventory_item_id = p_inventory_item_id and
515: organization_id = p_inventory_org_id;
516:
517: l_primary_uom VARCHAR2(10);

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 2609: mtl_system_items_b msi

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
2613: AND msi.organization_id = c_organization_id

Line 2626: mtl_system_items_b msi,

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
2630: AND mcr.parent_relationship_id is null

Line 2642: mtl_system_items_b msi,

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
2646: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'

Line 2662: mtl_system_items_b msi,

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
2666: AND mcr.parent_relationship_id is null

Line 2682: mtl_system_items_b msi,

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
2686: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'