APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 441: FROM mtl_system_items_b

437: SELECT lot_control_code,
438: serial_number_control_code
439: INTO l_lot_control_code,
440: l_serial_control_code
441: FROM mtl_system_items_b
442: WHERE inventory_item_id = p_item_id
443: AND organization_id = p_organization_id;
444:
445: IF l_lot_control_code <> 1 OR l_serial_control_code <> 1

Line 1809: mtl_system_items_b msib

1805: po_line_locations_all plla,
1806: po_lines_all pla,
1807: po_headers_all pha,
1808: mtl_interorg_parameters mip,
1809: mtl_system_items_b msib
1810: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1811: AND TO_NUMBER(hoi.org_information3) = pha.vendor_id
1812: AND TO_NUMBER(hoi.org_information4) = pha.vendor_site_id
1813: AND mip.to_organization_id = plla.ship_to_organization_id

Line 2123: FROM mtl_system_items

2119: WHERE line_id = l_order_line_id;
2120:
2121: SELECT primary_uom_code
2122: INTO l_primary_uom
2123: FROM mtl_system_items
2124: WHERE inventory_item_id = l_component_id
2125: AND organization_id = l_tp_organization_id;
2126:
2127: l_ordered_uom:= JMF_SHIKYU_UTIL.Get_UOM_Code(l_po_uom);

Line 3419: l_osa_item MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;

3415: l_po_qty NUMBER;
3416: l_comp_qty NUMBER;
3417: l_msg_data VARCHAR2(2000);
3418: l_msg_count NUMBER;
3419: l_osa_item MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
3420: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
3421: l_message VARCHAR(2000);
3422: l_status_flag BOOLEAN;
3423:

Line 3616: FROM mtl_system_items_b

3612: /* Log the error in the Concurrent Request log */
3613: BEGIN
3614:
3615: SELECT segment1 INTO l_osa_item
3616: FROM mtl_system_items_b
3617: WHERE inventory_item_id = l_osa_tbl(i).osa_item_id
3618: AND organization_id = l_osa_tbl(i).tp_organization_id ;
3619:
3620: SELECT organization_code INTO l_tp_organization