DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_CROSS_REFERENCES

Line 1195: mtl_cross_references mcr

1191: BEGIN
1192: SELECT 'C'
1193: INTO l_item_type
1194: FROM mtl_material_transactions_temp mmtt,
1195: mtl_cross_references mcr
1196: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1197: AND mmtt.inventory_item_id = mcr.inventory_item_id
1198: AND mcr.cross_reference_type = g_gtin_cross_ref_type
1199: AND (mcr.organization_id = mmtt.organization_id