APPS.WMS_RULE_16 dependencies on MTL_LOT_NUMBERS

Line 86: MTL_LOT_NUMBERS mlna ,

82: from PA_TASKS pt
83: ,PJM_PROJECTS_ORG_V ppovs
84: ,MTL_ITEM_LOCATIONS mil
85: ,
86: MTL_LOT_NUMBERS mlna ,
87: WMS_TRX_DETAILS_TMP_V mptdtv
88: ,(
89: select msn.current_organization_id organization_id
90: ,msn.inventory_item_id

Line 120: ,mtl_lot_numbers lot

116: ,NULL location_current_units
117: from mtl_serial_numbers msn
118: ,mtl_secondary_inventories sub
119: ,mtl_item_locations loc
120: ,mtl_lot_numbers lot
121: where msn.current_status = 3
122: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
123: decode(g_unit_number, '-9999', 'a', g_unit_number)
124: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 183: MTL_LOT_NUMBERS mlna ,

179: from PA_TASKS pt
180: ,PJM_PROJECTS_ORG_V ppovs
181: ,MTL_ITEM_LOCATIONS mil
182: ,
183: MTL_LOT_NUMBERS mlna ,
184: WMS_TRX_DETAILS_TMP_V mptdtv
185: ,(
186: select msn.current_organization_id organization_id
187: ,msn.inventory_item_id

Line 217: ,mtl_lot_numbers lot

213: ,NULL location_current_units
214: from mtl_serial_numbers msn
215: ,mtl_secondary_inventories sub
216: ,mtl_item_locations loc
217: ,mtl_lot_numbers lot
218: where msn.current_status = 3
219: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
220: decode(g_unit_number, '-9999', 'a', g_unit_number)
221: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 296: MTL_LOT_NUMBERS mlna ,

292: from PA_TASKS pt
293: ,PJM_PROJECTS_ORG_V ppovs
294: ,MTL_ITEM_LOCATIONS mil
295: ,
296: MTL_LOT_NUMBERS mlna ,
297: WMS_TRX_DETAILS_TMP_V mptdtv
298: ,(
299: select msn.current_organization_id organization_id
300: ,msn.inventory_item_id

Line 330: ,mtl_lot_numbers lot

326: ,NULL location_current_units
327: from mtl_serial_numbers msn
328: ,mtl_secondary_inventories sub
329: ,mtl_item_locations loc
330: ,mtl_lot_numbers lot
331: where msn.current_status = 3
332: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
333: decode(g_unit_number, '-9999', 'a', g_unit_number)
334: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 406: MTL_LOT_NUMBERS mlna ,

402: from PA_TASKS pt
403: ,PJM_PROJECTS_ORG_V ppovs
404: ,MTL_ITEM_LOCATIONS mil
405: ,
406: MTL_LOT_NUMBERS mlna ,
407: WMS_TRX_DETAILS_TMP_V mptdtv
408: ,(
409: SELECT x.organization_id organization_id
410: ,x.inventory_item_id inventory_item_id

Line 495: ,mtl_lot_numbers lot

491: HAVING
492: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
493: ) x
494: ,mtl_secondary_inventories sub
495: ,mtl_lot_numbers lot
496: where
497: -- x.primary_quantity > 0 and -- high volume project 8546026
498: x.organization_id = sub.organization_id
499: and x.subinventory_code = sub.secondary_inventory_name