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 1034: FROM mtl_system_items_b

1030: BEGIN
1031:
1032: SELECT mtl_transactions_enabled_flag
1033: INTO l_transactable_flag
1034: FROM mtl_system_items_b
1035: WHERE inventory_item_id = p_content_item_id
1036: AND organization_id = p_organization_id;
1037:
1038: EXCEPTION

Line 2376: FROM mtl_system_items

2372: --Get primary UOM - for bug fix 3609203
2373: BEGIN
2374: SELECT primary_uom_code
2375: INTO l_primary_uom
2376: FROM mtl_system_items
2377: WHERE inventory_item_id = p_item_id
2378: AND organization_id = p_org_id ;
2379:
2380: END; --get primary uom

Line 3319: FROM mtl_system_items

3315: AND unit_of_measure = p_unit_of_measure;
3316:
3317: SELECT primary_uom_code, lot_control_code
3318: INTO l_item_primary_uom, l_lot_control_code
3319: FROM mtl_system_items
3320: WHERE inventory_item_id = p_item_id
3321: AND organization_id = p_org_id;
3322:
3323: -- BEGIN

Line 3327: -- mtl_system_items msi

3323: -- BEGIN
3324: -- SELECT wlc.lot_number
3325: -- INTO l_lot_number
3326: --FROM wms_lpn_contents wlc,
3327: -- mtl_system_items msi
3328: --WHERE wlc.parent_lpn_id = p_lpn_id
3329: --AND wlc.organization_id = p_org_id
3330: --AND wlc.inventory_item_id = p_item_id
3331: --AND msi.inventory_item_id = p_item_id