APPS.INV_LABEL_PVT2 dependencies on WIP_ENTITIES

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

407: , wnt.wip_entity_id
408: FROM mtl_material_transactions_temp mmtt
409: , mtl_transaction_lots_temp mtlt
410: , mtl_serial_numbers_temp msnt
411: , wip_entities wnt --Added for Bug 4642062
412: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
413: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
414: AND mmtt.transaction_temp_id = p_transaction_id
415: AND wnt.wip_entity_id(+) = mmtt.transaction_source_id;--Added for Bug 4642062

Line 505: FROM wip_entities wipent

501: , TO_CHAR(wipdj.scheduled_start_date, g_date_format_mask) job_scheduled_start_date
502: , TO_CHAR(wipdj.scheduled_completion_date, g_date_format_mask) job_scheduled_completion_date
503: , wipdj.bom_revision job_bom_revision
504: , wipdj.routing_revision job_routing_revision
505: FROM wip_entities wipent
506: , wip_discrete_jobs wipdj
507: , mfg_lookups mfglkp
508: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
509: AND wipdj.organization_id = wipent.organization_id

Line 1000: , wip_entities wipent

996: , mtl_material_statuses_vl mmsvl2
997: , po_hazard_classes poh
998: , mtl_serial_numbers msn
999: , cst_cost_groups ccg
1000: , wip_entities wipent
1001: , wms_item_locations_kfv wilk -- Modified for bug # 5015415
1002: -- , mtl_item_locations_kfv milk -- Added as part of change for patchset "I".
1003: WHERE msik.inventory_item_id = l_inventory_item_id
1004: AND msik.organization_id = l_organization_id

Line 1140: l_wip_entity_name wip_entities.wip_entity_name%TYPE;

1136: -- a list of columns that are selected for format
1137: l_column_name_list LONG;
1138: l_patch_level NUMBER;
1139: -- Added the variable for Bug 4642062 to store the job name
1140: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
1141:
1142: --Start: Enabling EPC generation for R12 Project
1143: l_epc VARCHAR2(300);
1144: l_epc_ret_status VARCHAR2(10);

Line 1751: FROM wip_entities wipent

1747: , l_scheduled_start_date
1748: , l_scheduled_completion_date
1749: , l_bom_revision
1750: , l_routing_revision
1751: FROM wip_entities wipent
1752: , wip_discrete_jobs wipdj
1753: , mfg_lookups mfglkp
1754: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
1755: AND wipdj.organization_id = wipent.organization_id

Line 3505: FROM wip_entities wipent

3501: , l_scheduled_start_date
3502: , l_scheduled_completion_date
3503: , l_bom_revision
3504: , l_routing_revision
3505: FROM wip_entities wipent
3506: , wip_discrete_jobs wipdj
3507: , mfg_lookups mfglkp
3508: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
3509: AND wipdj.organization_id = wipent.organization_id