APPS.PO_RELGEN_PKG dependencies on MTL_SYSTEM_ITEMS

Line 37: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

33: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
34:
35: --
36: g_chktype_TRACKING_QTY_IND CONSTANT
37: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE
38: := 'PS';
39:
40: g_bpamsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_BLANKET_PO'),1,26) ;--12553671
41:

Line 1681: from mtl_system_items msi

1677: rcv_controls.allow_substitute_receipts_flag,
1678: rcv_controls.qty_rcv_exception_code,
1679: rcv_controls.receipt_required_flag,
1680: rcv_controls.receipt_days_exception_code
1681: from mtl_system_items msi
1682: where msi.inventory_item_id = req_line.item_id
1683: and msi.organization_id = req_line.destination_organization_id;
1684: END IF;
1685:

Line 1707: from mtl_system_items

1703: into rcv_controls.receipt_close_tolerance,
1704: rcv_controls.invoice_close_tolerance,
1705: rcv_controls.receipt_required_flag,
1706: rcv_controls.inspection_required_flag
1707: from mtl_system_items
1708: where organization_id = x_inventory_org_id
1709: and inventory_item_id = req_line.item_id;
1710: EXCEPTION
1711: WHEN NO_DATA_FOUND THEN

Line 2694: FROM MTL_SYSTEM_ITEMS MSI,

2690: -- bug 432746.
2691: SELECT NVL(MSI.price_tolerance_percent/100,
2692: NVL(POSP.price_change_allowance/100,-1))
2693: INTO l_price_tolerance_allowed
2694: FROM MTL_SYSTEM_ITEMS MSI,
2695: PO_SYSTEM_PARAMETERS POSP,
2696: FINANCIALS_SYSTEM_PARAMETERS FSP
2697: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
2698: AND MSI.organization_id(+) = FSP.inventory_organization_id;

Line 3129: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3125: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3126: g_linemsg||g_delim||p_req_line_num||
3127: g_delim||l_textline,1,240)
3128: BULK COLLECT INTO l_error_messages
3129: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3130: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3131: FINANCIALS_SYSTEM_PARAMETERS FSP
3132: WHERE POR.po_release_id = x_po_release_id
3133: AND POR.po_header_id = POH.po_header_id

Line 3203: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3199: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3200: g_linemsg||g_delim||p_req_line_num||
3201: g_delim||l_textline,1,240)
3202: BULK COLLECT INTO l_error_messages
3203: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3204: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3205: FINANCIALS_SYSTEM_PARAMETERS FSP
3206: WHERE POR.po_release_id = x_po_release_id
3207: AND POR.po_header_id = POH.po_header_id