APPS.CSP_PICK_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 117: mtl_system_items_b_kfv msibk,

113: ,mtrh.move_order_type
114: ,mtrl.quantity_detailed
115: ,mtrl.quantity
116: FROM mtl_item_locations_kfv milk,
117: mtl_system_items_b_kfv msibk,
118: csp_moveorder_lines cmol,
119: mtl_txn_request_lines mtrl,
120: mtl_txn_request_headers mtrh
121: WHERE mtrl.line_status in (3,7)

Line 154: mtl_system_items_b_kfv msibk,

150: ,mtrh.move_order_type
151: ,mtrl.quantity_detailed
152: ,mtrl.quantity
153: FROM mtl_item_locations_kfv milk,
154: mtl_system_items_b_kfv msibk,
155: csp_moveorder_lines cmol,
156: mtl_txn_request_lines mtrl,
157: mtl_txn_request_headers mtrh
158: WHERE mtrl.line_status in (3,7)

Line 191: mtl_system_items_b_kfv msibk,

187: ,mtrh.move_order_type
188: ,mtrl.quantity_detailed
189: ,mtrl.quantity
190: FROM mtl_item_locations_kfv milk,
191: mtl_system_items_b_kfv msibk,
192: csp_moveorder_lines cmol,
193: mtl_txn_request_lines mtrl,
194: mtl_txn_request_headers mtrh
195: WHERE mtrl.line_status in (3,7)

Line 228: mtl_system_items_b_kfv msibk,

224: ,mtrh.move_order_type
225: ,mtrl.quantity_detailed
226: ,mtrl.quantity
227: FROM mtl_item_locations_kfv milk,
228: mtl_system_items_b_kfv msibk,
229: csp_moveorder_lines cmol,
230: mtl_txn_request_lines mtrl,
231: mtl_txn_request_headers mtrh
232: WHERE mtrl.line_status in (3,7)

Line 265: mtl_system_items_b_kfv msibk,

261: ,mtrh.move_order_type
262: ,mtrl.quantity_detailed
263: ,mtrl.quantity
264: FROM mtl_item_locations_kfv milk,
265: mtl_system_items_b_kfv msibk,
266: csp_moveorder_lines cmol,
267: mtl_txn_request_lines mtrl,
268: mtl_txn_request_headers mtrh
269: WHERE mtrl.line_status in (3,7)

Line 533: FROM mtl_system_items

529:
530: -- This code is used for auto detailing serial numbers
531:
532: SELECT serial_number_control_code into l_serial_control
533: FROM mtl_system_items
534: WHERE inventory_item_id = mo_line_rec.inventory_item_id
535: AND organization_id = p_org_id;
536:
537: IF l_serial_control = 1 THEN

Line 1319: -- mtl_system_items table.

1315: -- Procedure : Update_Misc_MMTT
1316: -- Purpose : This procedure updates the transaction source type, transaction type, and transaction action of the
1317: -- a mmtt temp table to 13 (Inventory), 2 (Inventory sub transfer) and 2 (Subinventory transfer), respectively.
1318: -- This procedure also updates the item_lot_control_code and the item_serial_control_code to that in the
1319: -- mtl_system_items table.
1320: --
1321: -- History :
1322: -- UserID Date Comments
1323: -- ----------- -------- --------------------------

Line 1618: FROM MTL_SYSTEM_ITEMS_KFV

1614: -- Check whether the item is under serial control and / or lot control.
1615: BEGIN
1616: SELECT nvl(lot_control_code, 1), nvl(serial_number_control_code,1)
1617: INTO l_item_lot_control_code, l_item_serial_control_code
1618: FROM MTL_SYSTEM_ITEMS_KFV
1619: WHERE inventory_item_id = l_csp_mtltxn_rec.inventory_item_id
1620: AND organization_id = l_csp_mtltxn_rec.organization_id;
1621:
1622: IF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) <> l_item_lot_control_code