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 2123: mtl_material_transactions_temp mmtt

2119: bom_departments bd,
2120: wip_requirement_operations wro,
2121: wip_discrete_jobs wdj,
2122: mtl_txn_request_lines mtrl,
2123: mtl_material_transactions_temp mmtt
2124: WHERE we.wip_entity_id = wdj.wip_entity_id
2125: AND we.organization_id = wdj.organization_id
2126: AND wl.line_id (+) = wdj.line_id
2127: AND wl.organization_id (+) = wdj.organization_id

Line 2163: mtl_material_transactions_temp mmtt,

2159: bom_departments bd,
2160: wip_requirement_operations wro,
2161: wip_repetitive_schedules wrs,
2162: mtl_txn_request_lines mtrl,
2163: mtl_material_transactions_temp mmtt,
2164: mtl_system_items_kfv msik,
2165: wip_entities we
2166: WHERE msik.inventory_item_id = we.primary_item_id
2167: AND msik.organization_id = we.organization_id

Line 2209: mtl_material_transactions_temp mmtt

2205: bom_operation_sequences bos,
2206: bom_operational_routings bor,
2207: wip_flow_schedules wfs,
2208: mtl_txn_request_lines mtrl,
2209: mtl_material_transactions_temp mmtt
2210: WHERE we.wip_entity_id = wfs.wip_entity_id
2211: AND we.organization_id = wfs.organization_id
2212: AND wl.line_id = wfs.line_id
2213: AND wl.organization_id = wfs.organization_id

Line 2310: FROM mtl_material_transactions_temp

2306:
2307:
2308: SELECT demand_source_header_id, organization_id
2309: INTO l_wip_entity_id, l_org_id
2310: FROM mtl_material_transactions_temp
2311: WHERE transaction_temp_id = p_temp_id;
2312:
2313: x_wip_entity_id := l_wip_entity_id;
2314:

Line 2346: mtl_material_transactions_temp mmtt

2342: wip_lines wl,
2343: bom_departments bd,
2344: wip_requirement_operations wro,
2345: wip_discrete_jobs wdj,
2346: mtl_material_transactions_temp mmtt
2347: WHERE we.wip_entity_id = wdj.wip_entity_id
2348: AND we.organization_id = wdj.organization_id
2349: AND wl.line_id (+) = wdj.line_id
2350: AND wl.organization_id (+) = wdj.organization_id

Line 2384: mtl_material_transactions_temp mmtt,

2380: wip_lines wl,
2381: bom_departments bd,
2382: wip_requirement_operations wro,
2383: wip_repetitive_schedules wrs,
2384: mtl_material_transactions_temp mmtt,
2385: mtl_system_items_kfv msik,
2386: wip_entities we
2387: WHERE msik.inventory_item_id = we.primary_item_id
2388: AND msik.organization_id = we.organization_id

Line 2428: mtl_material_transactions_temp mmtt

2424: bom_departments bd,
2425: bom_operation_sequences bos,
2426: bom_operational_routings bor,
2427: wip_flow_schedules wfs,
2428: mtl_material_transactions_temp mmtt
2429: WHERE we.wip_entity_id = wfs.wip_entity_id
2430: AND we.organization_id = wfs.organization_id
2431: AND wl.line_id = wfs.line_id
2432: AND wl.organization_id = wfs.organization_id

Line 2562: mtl_material_transactions_temp mmtt,

2558:
2559: CURSOR mtlt_csr IS
2560: SELECT mtlt.lot_number, mtlt.primary_quantity
2561: FROM
2562: mtl_material_transactions_temp mmtt,
2563: mtl_transaction_lots_temp mtlt
2564: WHERE mmtt.transaction_temp_id = p_temp_id
2565: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
2566:

Line 2597: mtl_material_transactions_temp mmtt,

2593: l_content_lpn_id,
2594: l_lpn_controlled_flag
2595: FROM
2596: mtl_system_items msi,
2597: mtl_material_transactions_temp mmtt,
2598: mtl_secondary_inventories msin
2599: WHERE mmtt.transaction_temp_id = p_temp_id
2600: AND mmtt.organization_id = msi.organization_id
2601: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 2758: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

2754: BEGIN
2755: /* Bug6604904. Modified query to get project and task info from MTRL */
2756: SELECT mmtt.organization_id, mtrl.project_id , mtrl.task_id
2757: INTO l_organization_id , l_project_id, l_task_id
2758: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2759: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2760: AND mmtt.move_order_line_id = mtrl.line_id ;
2761: EXCEPTION
2762: WHEN OTHERS THEN

Line 2885: UPDATE mtl_material_transactions_temp

2881: END IF; -- end if txn type is wip issue
2882:
2883: IF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2884: THEN
2885: UPDATE mtl_material_transactions_temp
2886: SET transaction_source_id = p_wip_entity_id
2887: , trx_source_line_id = p_operation_seq_num
2888: , demand_source_header_id = p_wip_entity_id
2889: , demand_source_line = p_operation_seq_num

Line 2919: UPDATE mtl_material_transactions_temp

2915: ELSIF p_transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
2916: --
2917: -- Bug 2057540: explicitly set WIP_SUPPLY_TYPE to null
2918: --
2919: UPDATE mtl_material_transactions_temp
2920: SET transaction_source_id = p_wip_entity_id
2921: , trx_source_line_id = p_operation_seq_num
2922: , demand_source_header_id = p_wip_entity_id
2923: , demand_source_line = p_operation_seq_num