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:
41: -- Private procedure:

Line 1665: from mtl_system_items msi

1661: rcv_controls.allow_substitute_receipts_flag,
1662: rcv_controls.qty_rcv_exception_code,
1663: rcv_controls.receipt_required_flag,
1664: rcv_controls.receipt_days_exception_code
1665: from mtl_system_items msi
1666: where msi.inventory_item_id = req_line.item_id
1667: and msi.organization_id = req_line.destination_organization_id;
1668: END IF;
1669:

Line 1691: from mtl_system_items

1687: into rcv_controls.receipt_close_tolerance,
1688: rcv_controls.invoice_close_tolerance,
1689: rcv_controls.receipt_required_flag,
1690: rcv_controls.inspection_required_flag
1691: from mtl_system_items
1692: where organization_id = x_inventory_org_id
1693: and inventory_item_id = req_line.item_id;
1694: EXCEPTION
1695: WHEN NO_DATA_FOUND THEN

Line 2669: FROM MTL_SYSTEM_ITEMS MSI,

2665: -- bug 432746.
2666: SELECT NVL(MSI.price_tolerance_percent/100,
2667: NVL(POSP.price_change_allowance/100,-1))
2668: INTO l_price_tolerance_allowed
2669: FROM MTL_SYSTEM_ITEMS MSI,
2670: PO_SYSTEM_PARAMETERS POSP,
2671: FINANCIALS_SYSTEM_PARAMETERS FSP
2672: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
2673: AND MSI.organization_id(+) = FSP.inventory_organization_id;

Line 3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3071: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3072: g_linemsg||g_delim||p_req_line_num||
3073: g_delim||l_textline,1,240)
3074: BULK COLLECT INTO l_error_messages
3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3076: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3077: FINANCIALS_SYSTEM_PARAMETERS FSP
3078: WHERE POR.po_release_id = x_po_release_id
3079: AND POR.po_header_id = POH.po_header_id

Line 3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3145: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3146: g_linemsg||g_delim||p_req_line_num||
3147: g_delim||l_textline,1,240)
3148: BULK COLLECT INTO l_error_messages
3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3150: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3151: FINANCIALS_SYSTEM_PARAMETERS FSP
3152: WHERE POR.po_release_id = x_po_release_id
3153: AND POR.po_header_id = POH.po_header_id