DBA Data[Home] [Help]

APPS.INV_LABEL_PVT9 dependencies on MTL_ITEM_LOCATIONS

Line 341: , mtl_item_locations mila

337: , mfg_lookups mfglkp1
338: , mfg_lookups mfglkp2
339: , mfg_lookups mfglkp3
340: , mtl_system_items_vl msik3
341: , mtl_item_locations mila
342: , mtl_parameters mp
343: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
344: AND wipdj.organization_id = wipent.organization_id
345: AND wipent.wip_entity_id = l_wip_entity_id

Line 402: -- , mtl_item_locations mil commented for bug 3776231

398: FROM mtl_txn_request_lines mtrl
399: , mtl_material_transactions_temp mmtt
400: , mtl_transaction_lots_temp mtlt
401: -- bug 3075322
402: -- , mtl_item_locations mil commented for bug 3776231
403: , wip_discrete_jobs wdj -- added for bug 3776231
404: -- Bug 2673874 : joabraha
405: , pa_projects pp
406: , pa_tasks pt

Line 443: -- , mtl_item_locations mil commented for bug 3776231

439: FROM mtl_txn_request_lines mtrl
440: , mtl_material_transactions_temp mmtt
441: , mtl_transaction_lots_temp mtlt
442: -- bug 3075322
443: -- , mtl_item_locations mil commented for bug 3776231
444: , wip_discrete_jobs wdj -- added for bug 3776231
445: -- Bug 2673874 : joabraha
446: , pa_projects pp
447: , pa_tasks pt

Line 755: , mtl_item_locations mila

751: , wip_discrete_jobs wipdj
752: , wip_repetitive_schedules wiprs
753: , wip_operations wipops
754: , wip_requirement_operations wipreqops
755: , mtl_item_locations mila
756: , mtl_item_locations milb
757: , mfg_lookups mfglkp1
758: , mfg_lookups mfglkp2
759: , mfg_lookups mfglkp3

Line 756: , mtl_item_locations milb

752: , wip_repetitive_schedules wiprs
753: , wip_operations wipops
754: , wip_requirement_operations wipreqops
755: , mtl_item_locations mila
756: , mtl_item_locations milb
757: , mfg_lookups mfglkp1
758: , mfg_lookups mfglkp2
759: , mfg_lookups mfglkp3
760: , mfg_lookups mfglkp4

Line 776: , mtl_item_locations milkfv

772: , mtl_lot_numbers mln
773: , cst_cost_groups ccg
774: , po_hazard_classes poh
775: , mtl_material_statuses_vl mmsv1
776: , mtl_item_locations milkfv
777: WHERE wipdj.wip_entity_id(+) = wipent.wip_entity_id
778: AND wipdj.organization_id(+) = wipent.organization_id
779: AND wiprs.wip_entity_id(+) = wipent.wip_entity_id
780: AND wiprs.organization_id(+) = wipent.organization_id