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.CSD_HV_WIP_JOB_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 873: l_transactions_interface_rec.transaction_interface_id, -- null, -- mtl_material_transactions_s.nextval, --l_transaction_interface_id,

869: l_transactions_interface_rec.transaction_mode,
870: l_transactions_interface_rec.process_flag,
871: l_transactions_interface_rec.source_header_id, -- 124743, -- ,
872: l_transactions_interface_rec.source_line_id, -- -1, --10,
873: l_transactions_interface_rec.transaction_interface_id, -- null, -- mtl_material_transactions_s.nextval, --l_transaction_interface_id,
874: l_transactions_interface_rec.reason_id, -- swai: bug 6841113
875: l_transactions_interface_rec.final_completion_flag ); -- 'N' ) ;
876:
877:

Line 1829: SELECT mtl_material_transactions_s.nextval from dual;

1825: wdj.primary_item_id = msi.inventory_item_id and
1826: wdj.organization_id = msi.organization_id;
1827:
1828: CURSOR get_mtl_header_id IS
1829: SELECT mtl_material_transactions_s.nextval from dual;
1830:
1831: CURSOR get_last_operation_dtls(c_org_id NUMBER) IS
1832: SELECT
1833: wo.quantity_waiting_to_move,

Line 2536: SELECT mtl_material_transactions_s.nextval from dual; */

2532: where rownum=1;
2533: -- end swai: bug 5330060
2534:
2535: /* CURSOR get_material_transaction_id IS
2536: SELECT mtl_material_transactions_s.nextval from dual; */
2537:
2538:
2539: BEGIN
2540:

Line 2899: SELECT mtl_material_transactions_s.nextval from dual;

2895: -- end swai: bug 13820264, FP of bug#13797285, subhat
2896:
2897:
2898: CURSOR get_mtl_header_id IS
2899: SELECT mtl_material_transactions_s.nextval from dual;
2900:
2901: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
2902: SELECT stock_locator_control_code from mtl_parameters
2903: where organization_id = p_organization_id;

Line 3942: SELECT mtl_material_transactions_s.nextval from dual;

3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:
3941: CURSOR get_mtl_header_id IS
3942: SELECT mtl_material_transactions_s.nextval from dual;
3943:
3944: BEGIN
3945:
3946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 9944: FROM mtl_material_transactions mmt,wip_requirement_operations wro

9940: THEN
9941: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_issued = (NVL(cwt.quantity_issued,0) + p_quantity)
9942: WHERE cwt.wip_transaction_detail_id = p_wip_transaction_detail_id
9943: AND EXISTS (SELECT SUM(transaction_quantity)
9944: FROM mtl_material_transactions mmt,wip_requirement_operations wro
9945: WHERE mmt.inventory_item_id = cwt.inventory_item_id
9946: AND wro.wip_entity_id = cwt.wip_entity_id
9947: AND wro.inventory_item_id = cwt.inventory_item_id
9948: AND wro.organization_id = mmt.organization_id

Line 9961: FROM mtl_material_transactions mmt,wip_requirement_operations wro

9957: THEN
9958: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_recovered = (NVL(cwt.quantity_recovered,0) + p_quantity)
9959: WHERE wip_transaction_detail_id = p_wip_transaction_detail_id
9960: AND EXISTS (SELECT SUM(transaction_quantity)
9961: FROM mtl_material_transactions mmt,wip_requirement_operations wro
9962: WHERE mmt.inventory_item_id = cwt.inventory_item_id
9963: AND wro.wip_entity_id = cwt.wip_entity_id
9964: AND wro.inventory_item_id = cwt.inventory_item_id
9965: AND wro.organization_id = mmt.organization_id

Line 9990: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

9986: handle_missing_mat_rqmts(p_wip_entity_id => p_wip_entity_id);
9987:
9988: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
9989: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
9990: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
9991: csd_wip_transaction_details cwt
9992: WHERE cwt.wip_entity_id = p_wip_entity_id
9993: AND cwt.wip_entity_id = wro.wip_entity_id
9994: AND cwt.inventory_item_id = wro.inventory_item_id

Line 10027: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10023: handle_missing_mat_rqmts(p_repair_line_id => p_repair_line_id);
10024:
10025: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10026: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10027: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10028: csd_wip_transaction_details cwt,csd_repair_job_xref crj
10029: WHERE crj.repair_line_id = p_repair_line_id
10030: AND cwt.wip_entity_id = crj.wip_entity_id
10031: AND cwt.wip_entity_id = wro.wip_entity_id

Line 10060: from mtl_material_transactions mmt, wip_requirement_operations wro,

10056: handle_missing_mat_rqmts(p_repair_line_id => p_repair_line_id);
10057:
10058: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10059: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10060: from mtl_material_transactions mmt, wip_requirement_operations wro,
10061: csd_wip_transaction_details cwt,csd_repair_job_xref crj,wip_discrete_jobs wdj
10062: WHERE crj.repair_line_id = p_repair_line_id
10063: AND cwt.wip_entity_id = crj.wip_entity_id
10064: AND cwt.wip_entity_id = wro.wip_entity_id

Line 10102: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10098: IF p_exclude_closed_jobs = 'N'
10099: THEN
10100: OPEN l_all_jobs FOR
10101: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10102: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10103: csd_wip_transaction_details cwt
10104: WHERE cwt.wip_entity_id = wro.wip_entity_id
10105: AND cwt.inventory_item_id = wro.inventory_item_id
10106: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10133: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10129: CLOSE l_all_jobs;
10130: ELSE
10131: OPEN l_all_jobs FOR
10132: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10133: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10134: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10135: WHERE cwt.wip_entity_id = wro.wip_entity_id
10136: AND cwt.inventory_item_id = wro.inventory_item_id
10137: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10170: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10166: IF p_exclude_closed_jobs = 'N'
10167: THEN
10168: OPEN l_all_jobs FOR
10169: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10170: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10171: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10172: WHERE cwt.wip_entity_id = wro.wip_entity_id
10173: AND cwt.inventory_item_id = wro.inventory_item_id
10174: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10204: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10200:
10201: ELSE
10202: OPEN l_all_jobs FOR
10203: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10204: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10205: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10206: WHERE cwt.wip_entity_id = wro.wip_entity_id
10207: AND cwt.inventory_item_id = wro.inventory_item_id
10208: AND cwt.operation_seq_num = wro.operation_seq_num