APPS.WMS_RETURN_SV dependencies on MTL_SYSTEM_ITEMS

Line 43: , mtl_system_items msi

39: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
40: , rsl.from_organization_id
41: , rsl.asn_line_flag
42: FROM rcv_shipment_lines rsl
43: , mtl_system_items msi
44: , rcv_transactions rt
45: WHERE rt.group_id = p_group_id
46: AND (rt.transaction_type = 'CORRECT'
47: -- return to receiving is also created for a rtv/rtc txn.

Line 83: , mtl_system_items msi

79: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
80: FROM mtl_transaction_lots_temp mtlt
81: , rcv_shipment_lines rsl
82: , rcv_transactions rt
83: , mtl_system_items msi
84: WHERE rt.group_id = p_group_id
85: AND (mtlt.transaction_temp_id (+) = rt.interface_transaction_id
86: -- Since mtlt is deleted for a correction record for a
87: -- deliver transaction, that record should be selected

Line 141: , mtl_system_items msi

137: FROM mtl_material_transactions mmt
138: , mtl_transaction_lot_numbers mtln
139: , rcv_shipment_lines rsl
140: , rcv_transactions rt
141: , mtl_system_items msi
142: WHERE rt.group_id = p_group_id
143: AND mmt.rcv_transaction_id = rt.transaction_id
144: AND mmt.transaction_id = mtln.transaction_id
145: -- should select in this part of the union only the cases which

Line 2429: FROM mtl_system_items

2425: --Get primary UOM - for bug fix 3609203
2426: BEGIN
2427: SELECT primary_uom_code
2428: INTO l_primary_uom
2429: FROM mtl_system_items
2430: WHERE inventory_item_id = p_item_id
2431: AND organization_id = p_org_id ;
2432:
2433: END; --get primary uom

Line 3258: FROM mtl_system_items

3254: l_trx_type_id := 88;
3255: --I will modify the below query ,to get control from Cache..
3256: /* SELECT LOT_CONTROL_CODE,SERIAL_NUMBER_CONTROL_CODE
3257: INTO l_lot_control_code,l_serial_control_code
3258: FROM mtl_system_items
3259: WHERE INVENTORY_ITEM_ID = l_item_id
3260: AND ORGANIZATION_ID = l_org_id
3261: AND ROWNUM <2 ; */
3262: /* SELECT mtl_material_transactions_s.NEXTVAL

Line 4231: FROM mtl_system_items

4227: AND unit_of_measure = p_unit_of_measure;
4228:
4229: SELECT primary_uom_code, lot_control_code
4230: INTO l_item_primary_uom, l_lot_control_code
4231: FROM mtl_system_items
4232: WHERE inventory_item_id = p_item_id
4233: AND organization_id = p_org_id;
4234:
4235: -- BEGIN

Line 4239: -- mtl_system_items msi

4235: -- BEGIN
4236: -- SELECT wlc.lot_number
4237: -- INTO l_lot_number
4238: --FROM wms_lpn_contents wlc,
4239: -- mtl_system_items msi
4240: --WHERE wlc.parent_lpn_id = p_lpn_id
4241: --AND wlc.organization_id = p_org_id
4242: --AND wlc.inventory_item_id = p_item_id
4243: --AND msi.inventory_item_id = p_item_id