DBA Data[Home] [Help]

APPS.POR_AUTOSOURCE_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 27: from mtl_system_items

23: BEGIN
24:
25: select internal_order_enabled_flag
26: into l_internal_order_enabled_flag
27: from mtl_system_items
28: where inventory_item_id = p_item_id
29: and organization_id = p_organization_id;
30:
31: IF l_internal_order_enabled_flag = 'Y' THEN

Line 60: from mtl_system_items

56: END IF;
57:
58: select purchasing_enabled_flag
59: into l_purchasable_flag
60: from mtl_system_items
61: where inventory_item_id = p_item_id
62: and organization_id = p_organization_id;
63:
64: IF l_purchasable_flag = 'Y' THEN

Line 88: from mtl_system_items msi

84:
85: BEGIN
86: select nvl(msi.unit_of_issue,msi.primary_unit_of_measure)
87: into l_unit_of_issue
88: from mtl_system_items msi
89: where msi.inventory_item_id = p_item_id
90: and msi.organization_id = p_organization_id;
91:
92: RETURN l_unit_of_issue;

Line 117: from mtl_system_items

113:
114: -- check the shippable, stockable, oe transactable and mtl_transactable flags
115: select shippable_item_flag, so_transactions_flag, stock_enabled_flag, mtl_transactions_enabled_flag
116: into l_shippable_flag, l_oe_transactable_flag, l_stockable_flag, l_mtl_transactable_flag
117: from mtl_system_items
118: where inventory_item_id = p_item_id
119: and organization_id = p_organization_id;
120:
121: IF l_shippable_flag='Y' and l_oe_transactable_flag='Y' and l_stockable_flag='Y' and l_mtl_transactable_flag='Y' THEN

Line 177: FROM mtl_system_items msi

173:
174: BEGIN
175:
176: SELECT 1 into l_is_item_assigned
177: FROM mtl_system_items msi
178: WHERE msi.inventory_item_id = p_item_id
179: and msi.organization_id = p_source_organization_id;
180:
181: IF l_is_item_assigned = '1' THEN

Line 303: mtl_system_items msi

299: (nvl(mos.total_qoh,0) - sum(nvl(mrs.primary_reservation_quantity,0))) avail_quantity
300: FROM mtl_secondary_inventories msub,
301: mtl_onhand_sub_v mos,
302: mtl_reservations mrs,
303: mtl_system_items msi
304: WHERE msub.organization_id = l_source_organization_id -- bug 5470125, do not bind p_source_organization_id
305: and msi.organization_id = l_source_organization_id
306: and msi.inventory_item_id = p_item_id
307: and (trunc(sysdate) < nvl(msub.disable_date, trunc(sysdate + 1)))