DBA Data[Home] [Help]

APPS.INV_INVLTATT_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 212: from mtl_system_items_b

208: AND mln.lot_number <= nvl(P_LOT_HI,mln.lot_number)
209: /*Item should be lot controlled,
210: Lot should exists in source and destination */
211: AND inventory_item_id in(select inventory_item_id
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

Line 393: from mtl_system_items_b msib,mtl_parameters mp

389: AND mln.lot_number <= nvl(P_LOT_HI,mln.lot_number)
390: /*Item should be lot controlled,
391: Lot should exists in source and destination */
392: AND inventory_item_id in(select inventory_item_id
393: from mtl_system_items_b msib,mtl_parameters mp
394: where msib.organization_id = mp.organization_id
395: and mp.organization_id <> P_SOURCE_ORG
396: and mp.organization_code >= P_DEST_ORG_CODE_LO
397: and mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)