eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WIP_INTEGRATION dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 137: -- Insert into mtl_material_transactions_temp

133: INTO l_temp_header_id,
134: l_temp_source_id;
135: EXIT when wip_lpn_completions_csr%NOTFOUND;
136:
137: -- Insert into mtl_material_transactions_temp
138:
139: --Get value from sequence for next transaction_temp_id
140: SELECT mtl_material_transactions_s.NEXTVAL
141: INTO l_next_transaction_temp_id

Line 148: INSERT INTO mtl_material_transactions_temp

144: IF (l_debug = 1) THEN
145: mydebug('Backflush: temp_id '||l_next_transaction_temp_id);
146: END IF;
147:
148: INSERT INTO mtl_material_transactions_temp
149: ( transaction_temp_id,
150: transaction_header_id,
151: source_code,
152: last_update_date,

Line 2153: mtl_material_transactions_temp mmtt

2149: bom_departments bd,
2150: wip_requirement_operations wro,
2151: wip_discrete_jobs wdj,
2152: mtl_txn_request_lines mtrl,
2153: mtl_material_transactions_temp mmtt
2154: WHERE we.wip_entity_id = wdj.wip_entity_id
2155: AND we.organization_id = wdj.organization_id
2156: AND wl.line_id (+) = wdj.line_id
2157: AND wl.organization_id (+) = wdj.organization_id

Line 2193: mtl_material_transactions_temp mmtt,

2189: bom_departments bd,
2190: wip_requirement_operations wro,
2191: wip_repetitive_schedules wrs,
2192: mtl_txn_request_lines mtrl,
2193: mtl_material_transactions_temp mmtt,
2194: mtl_system_items_kfv msik,
2195: wip_entities we
2196: WHERE msik.inventory_item_id = we.primary_item_id
2197: AND msik.organization_id = we.organization_id

Line 2239: mtl_material_transactions_temp mmtt

2235: bom_operation_sequences bos,
2236: bom_operational_routings bor,
2237: wip_flow_schedules wfs,
2238: mtl_txn_request_lines mtrl,
2239: mtl_material_transactions_temp mmtt
2240: WHERE we.wip_entity_id = wfs.wip_entity_id
2241: AND we.organization_id = wfs.organization_id
2242: AND wl.line_id = wfs.line_id
2243: AND wl.organization_id = wfs.organization_id

Line 2340: FROM mtl_material_transactions_temp

2336:
2337:
2338: SELECT demand_source_header_id, organization_id
2339: INTO l_wip_entity_id, l_org_id
2340: FROM mtl_material_transactions_temp
2341: WHERE transaction_temp_id = p_temp_id;
2342:
2343: x_wip_entity_id := l_wip_entity_id;
2344:

Line 2376: mtl_material_transactions_temp mmtt

2372: wip_lines wl,
2373: bom_departments bd,
2374: wip_requirement_operations wro,
2375: wip_discrete_jobs wdj,
2376: mtl_material_transactions_temp mmtt
2377: WHERE we.wip_entity_id = wdj.wip_entity_id
2378: AND we.organization_id = wdj.organization_id
2379: AND wl.line_id (+) = wdj.line_id
2380: AND wl.organization_id (+) = wdj.organization_id

Line 2414: mtl_material_transactions_temp mmtt,

2410: wip_lines wl,
2411: bom_departments bd,
2412: wip_requirement_operations wro,
2413: wip_repetitive_schedules wrs,
2414: mtl_material_transactions_temp mmtt,
2415: mtl_system_items_kfv msik,
2416: wip_entities we
2417: WHERE msik.inventory_item_id = we.primary_item_id
2418: AND msik.organization_id = we.organization_id

Line 2458: mtl_material_transactions_temp mmtt

2454: bom_departments bd,
2455: bom_operation_sequences bos,
2456: bom_operational_routings bor,
2457: wip_flow_schedules wfs,
2458: mtl_material_transactions_temp mmtt
2459: WHERE we.wip_entity_id = wfs.wip_entity_id
2460: AND we.organization_id = wfs.organization_id
2461: AND wl.line_id = wfs.line_id
2462: AND wl.organization_id = wfs.organization_id

Line 2592: mtl_material_transactions_temp mmtt,

2588:
2589: CURSOR mtlt_csr IS
2590: SELECT mtlt.lot_number, mtlt.primary_quantity
2591: FROM
2592: mtl_material_transactions_temp mmtt,
2593: mtl_transaction_lots_temp mtlt
2594: WHERE mmtt.transaction_temp_id = p_temp_id
2595: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
2596:

Line 2627: mtl_material_transactions_temp mmtt,

2623: l_content_lpn_id,
2624: l_lpn_controlled_flag
2625: FROM
2626: mtl_system_items msi,
2627: mtl_material_transactions_temp mmtt,
2628: mtl_secondary_inventories msin
2629: WHERE mmtt.transaction_temp_id = p_temp_id
2630: AND mmtt.organization_id = msi.organization_id
2631: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 2788: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

2784: BEGIN
2785: /* Bug6604904. Modified query to get project and task info from MTRL */
2786: SELECT mmtt.organization_id, mtrl.project_id , mtrl.task_id
2787: INTO l_organization_id , l_project_id, l_task_id
2788: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2789: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2790: AND mmtt.move_order_line_id = mtrl.line_id ;
2791: EXCEPTION
2792: WHEN OTHERS THEN

Line 2915: UPDATE mtl_material_transactions_temp

2911: END IF; -- end if txn type is wip issue
2912:
2913: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2914: THEN
2915: UPDATE mtl_material_transactions_temp
2916: SET transaction_source_id = p_wip_entity_id
2917: , trx_source_line_id = p_operation_seq_num
2918: , demand_source_header_id = p_wip_entity_id
2919: , demand_source_line = p_operation_seq_num

Line 2949: UPDATE mtl_material_transactions_temp

2945: ELSIF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
2946: --
2947: -- Bug 2057540: explicitly set WIP_SUPPLY_TYPE to null
2948: --
2949: UPDATE mtl_material_transactions_temp
2950: SET transaction_source_id = p_wip_entity_id
2951: , trx_source_line_id = p_operation_seq_num
2952: , demand_source_header_id = p_wip_entity_id
2953: , demand_source_line = p_operation_seq_num