APPS.INV_LABEL_PVT2 dependencies on WIP_ENTITIES

Line 406: , wip_entities wnt --Added for Bug 4642062

402: , wnt.wip_entity_id
403: FROM mtl_material_transactions_temp mmtt
404: , mtl_transaction_lots_temp mtlt
405: , mtl_serial_numbers_temp msnt
406: , wip_entities wnt --Added for Bug 4642062
407: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
408: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
409: AND mmtt.transaction_temp_id = p_transaction_id
410: AND wnt.wip_entity_id(+) = mmtt.transaction_source_id;--Added for Bug 4642062

Line 500: FROM wip_entities wipent

496: , TO_CHAR(wipdj.scheduled_start_date, g_date_format_mask) job_scheduled_start_date
497: , TO_CHAR(wipdj.scheduled_completion_date, g_date_format_mask) job_scheduled_completion_date
498: , wipdj.bom_revision job_bom_revision
499: , wipdj.routing_revision job_routing_revision
500: FROM wip_entities wipent
501: , wip_discrete_jobs wipdj
502: , mfg_lookups mfglkp
503: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
504: AND wipdj.organization_id = wipent.organization_id

Line 993: , wip_entities wipent

989: , mtl_material_statuses_vl mmsvl2
990: , po_hazard_classes poh
991: , mtl_serial_numbers msn
992: , cst_cost_groups ccg
993: , wip_entities wipent
994: , wms_item_locations_kfv wilk -- Modified for bug # 5015415
995: -- , mtl_item_locations_kfv milk -- Added as part of change for patchset "I".
996: WHERE msik.inventory_item_id = l_inventory_item_id
997: AND msik.organization_id = l_organization_id

Line 1133: l_wip_entity_name wip_entities.wip_entity_name%TYPE;

1129: -- a list of columns that are selected for format
1130: l_column_name_list LONG;
1131: l_patch_level NUMBER;
1132: -- Added the variable for Bug 4642062 to store the job name
1133: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
1134:
1135: --Start: Enabling EPC generation for R12 Project
1136: l_epc VARCHAR2(300);
1137: l_epc_ret_status VARCHAR2(10);