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 2051: l_subcontracting_component MTL_SYSTEM_ITEMS.subcontracting_component%TYPE;

2047:
2048: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Allocations';
2049: l_api_version CONSTANT NUMBER := 1.0;
2050:
2051: l_subcontracting_component MTL_SYSTEM_ITEMS.subcontracting_component%TYPE;
2052:
2053: g_non_shikyu_component_exc EXCEPTION;
2054:
2055: BEGIN

Line 2078: FROM MTL_SYSTEM_ITEMS_B msib,

2074: -- Get the type of the SHIKYU Component, since the allocation logic is
2075: -- different for Pre-positioned and Sync-ship components
2076: SELECT msib.subcontracting_component
2077: INTO l_subcontracting_component
2078: FROM MTL_SYSTEM_ITEMS_B msib,
2079: JMF_SUBCONTRACT_ORDERS jso
2080: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2081: AND msib.inventory_item_id = p_component_id
2082: AND msib.organization_id = jso.tp_organization_id;

Line 2232: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;

2228:
2229: l_available_replen_tbl g_replen_so_qty_tbl_type;
2230: l_remaining_qty NUMBER;
2231: l_qty_allocated NUMBER;
2232: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
2233: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2234: l_message VARCHAR(2000);
2235: l_status_flag BOOLEAN;
2236: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;

Line 2369: FROM mtl_system_items_b msi

2365: AND poll.po_header_id = poh.po_header_id);
2366:
2367: SELECT segment1
2368: INTO l_sub_comp
2369: FROM mtl_system_items_b msi
2370: WHERE inventory_item_id = p_component_id
2371: AND exists
2372: (SELECT 1
2373: FROM jmf_subcontract_orders jso