DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_PARAMETERS

Line 264: FROM mtl_parameters

260: (SELECT mcr.attribute1
261: FROM mtl_cross_references_vl mcr
262: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
263: AND mcr.organization_id = (SELECT master_organization_id
264: FROM mtl_parameters
265: WHERE organization_id=msi.organization_id+0)
266: AND mcr.cross_reference_type ='OPSM INTEGRATED'
267: AND mcr.cross_reference = 'YES') serial_type ,
268: NULL parent_lot_number ,

Line 336: FROM mtl_parameters

332: (SELECT mcr.attribute1
333: FROM mtl_cross_references_vl mcr
334: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
335: AND mcr.organization_id = (SELECT master_organization_id
336: FROM mtl_parameters
337: WHERE organization_id=msi.organization_id+0)
338: AND mcr.cross_reference_type ='OPSM INTEGRATED'
339: AND mcr.cross_reference = 'YES') serial_type,
340: NULL parent_lot_number ,

Line 409: FROM mtl_parameters

405: (SELECT mcr.attribute1
406: FROM mtl_cross_references_vl mcr
407: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
408: AND mcr.organization_id = (SELECT master_organization_id
409: FROM mtl_parameters
410: WHERE organization_id=msi.organization_id+0)
411: AND mcr.cross_reference_type ='OPSM INTEGRATED'
412: AND mcr.cross_reference = 'YES') serial_type,
413: NULL parent_lot_number ,