APPS.INV_INVLTATT_XMLP_PKG dependencies on MTL_LOT_NUMBERS

Line 205: FROM mtl_lot_numbers mln

201: n_attribute7,
202: n_attribute8,
203: n_attribute9,
204: n_attribute10
205: FROM mtl_lot_numbers mln
206: WHERE organization_id=P_SOURCE_ORG
207: AND mln.lot_number >= nvl(P_LOT_LO,mln.lot_number)
208: AND mln.lot_number <= nvl(P_LOT_HI,mln.lot_number)
209: /*Item should be lot controlled,

Line 216: AND exists(select 'x' from mtl_lot_numbers mln1,mtl_parameters mp

212: from mtl_system_items_b
213: where (organization_id = P_SOURCE_ORG)
214: and (segment1 >= nvl(P_ITEM_LO,segment1) and segment1<=nvl(P_ITEM_HI,segment1))
215: and (lot_control_code = 2))
216: AND exists(select 'x' from mtl_lot_numbers mln1,mtl_parameters mp
217: where mln1.organization_id = mp.organization_id
218: and mp.organization_id <> P_SOURCE_ORG
219: and mp.organization_code >= P_DEST_ORG_CODE_LO
220: and mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)

Line 383: FROM mtl_lot_numbers mln,mtl_parameters mp

379: mln.n_attribute7,
380: mln.n_attribute8,
381: mln.n_attribute9,
382: mln.n_attribute10
383: FROM mtl_lot_numbers mln,mtl_parameters mp
384: WHERE mln.organization_id = mp.organization_id
385: AND mp.organization_id <> P_SOURCE_ORG
386: AND mp.organization_code >= P_DEST_ORG_CODE_LO
387: AND mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)

Line 400: AND exists(select 'x' from mtl_lot_numbers mln1

396: and mp.organization_code >= P_DEST_ORG_CODE_LO
397: and mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)
398: and (msib.segment1 >= nvl(P_ITEM_LO,msib.segment1) and msib.segment1<=nvl(P_ITEM_HI,msib.segment1))
399: and msib.lot_control_code = 2)
400: AND exists(select 'x' from mtl_lot_numbers mln1
401: where mln1.organization_id = P_SOURCE_ORG
402: and mln1.lot_number = mln.lot_number
403: and mln1.inventory_item_id = mln.inventory_item_id)
404: /*Skip the lot if pending transaction exists */