APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 369: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;

365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
366: l_allocated_uom JMF_SHIKYU_ALLOCATIONS.uom%TYPE;
367: l_allocation_qty JMF_SHIKYU_ALLOCATIONS.allocated_quantity%TYPE;
368: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE := NULL;
369: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
370: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
371: l_message VARCHAR(2000);
372: l_status_flag BOOLEAN;
373:

Line 530: FROM mtl_system_items_b

526: AND poll.po_header_id = poh.po_header_id);
527:
528: SELECT segment1
529: INTO l_sub_comp
530: FROM mtl_system_items_b
531: WHERE inventory_item_id = p_component_id
532: AND organization_id = l_tp_organization_id ;
533:
534: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');

Line 2057: l_subcontracting_component MTL_SYSTEM_ITEMS.subcontracting_component%TYPE;

2053:
2054: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Allocations';
2055: l_api_version CONSTANT NUMBER := 1.0;
2056:
2057: l_subcontracting_component MTL_SYSTEM_ITEMS.subcontracting_component%TYPE;
2058:
2059: g_non_shikyu_component_exc EXCEPTION;
2060:
2061: BEGIN

Line 2084: FROM MTL_SYSTEM_ITEMS_B msib,

2080: -- Get the type of the SHIKYU Component, since the allocation logic is
2081: -- different for Pre-positioned and Sync-ship components
2082: SELECT msib.subcontracting_component
2083: INTO l_subcontracting_component
2084: FROM MTL_SYSTEM_ITEMS_B msib,
2085: JMF_SUBCONTRACT_ORDERS jso
2086: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2087: AND msib.inventory_item_id = p_component_id
2088: AND msib.organization_id = jso.tp_organization_id;

Line 2238: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;

2234:
2235: l_available_replen_tbl g_replen_so_qty_tbl_type;
2236: l_remaining_qty NUMBER;
2237: l_qty_allocated NUMBER;
2238: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
2239: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2240: l_message VARCHAR(2000);
2241: l_status_flag BOOLEAN;
2242: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;

Line 2375: FROM mtl_system_items_b msi

2371: AND poll.po_header_id = poh.po_header_id);
2372:
2373: SELECT segment1
2374: INTO l_sub_comp
2375: FROM mtl_system_items_b msi
2376: WHERE inventory_item_id = p_component_id
2377: AND exists
2378: (SELECT 1
2379: FROM jmf_subcontract_orders jso