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 DUAL

Line 340: x_job_name From Dual;

336: -- generate the Job Name by appending a sequence generated number to the passed in
337: -- job_prefix
338:
339: Select p_job_prefix || TO_CHAR( CSD_JOB_NAME_S.NEXTVAL ) into
340: x_job_name From Dual;
341:
342:
343: -- Check if the job name generated is unique for the specified organization,
344: -- if not loop around till a unique job name is generated

Line 1624: SELECT mtl_material_transactions_s.nextval from dual;

1620: wdj.primary_item_id = msi.inventory_item_id and
1621: wdj.organization_id = msi.organization_id;
1622:
1623: CURSOR get_mtl_header_id IS
1624: SELECT mtl_material_transactions_s.nextval from dual;
1625:
1626: CURSOR get_last_operation_dtls(c_org_id NUMBER) IS
1627: SELECT
1628: wo.quantity_waiting_to_move,

Line 2173: SELECT wip_transactions_s.nextval from dual;

2169: l_qty_in_queue NUMBER := 0;
2170: -- end swai: bug 5330060
2171:
2172: CURSOR get_transaction_id IS
2173: SELECT wip_transactions_s.nextval from dual;
2174:
2175:
2176: Cursor check_mv_interface_errors ( c_group_id NUMBER ) IS
2177: select 'exists' from wip_move_txn_interface where

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

2195: where rownum=1;
2196: -- end swai: bug 5330060
2197:
2198: /* CURSOR get_material_transaction_id IS
2199: SELECT mtl_material_transactions_s.nextval from dual; */
2200:
2201:
2202: BEGIN
2203:

Line 2554: SELECT mtl_material_transactions_s.nextval from dual;

2550:
2551:
2552:
2553: CURSOR get_mtl_header_id IS
2554: SELECT mtl_material_transactions_s.nextval from dual;
2555:
2556: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
2557: SELECT stock_locator_control_code from mtl_parameters
2558: where organization_id = p_organization_id;

Line 2653: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

2649: -- l_job_details_rec.wip_supply_type := lc_push_wip_supply_type;
2650: l_job_details_rec.wip_supply_type := null;
2651: -- Get the Group_id to be used for WIP Mass Load,
2652:
2653: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
2654:
2655: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
2656:
2657: l_job_details_rec.group_id := l_job_header_rec.group_id;

Line 3006: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;

3002:
3003:
3004: -- Get the Group_id to be used for WIP Mass Load,
3005:
3006: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;
3007:
3008: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3009:
3010: -- l_job_details_rec.group_id := l_job_header_rec.header_id;

Line 3015: -- SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;

3011: l_job_details_rec.parent_header_id := l_job_header_rec.header_id;
3012:
3013:
3014:
3015: -- SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
3016:
3017:
3018: --Commenting out as don't think this is needed
3019: -- Need to remove ro_quantity as well, later on if not neede

Line 3505: SELECT mtl_material_transactions_s.nextval from dual;

3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3503:
3504: CURSOR get_mtl_header_id IS
3505: SELECT mtl_material_transactions_s.nextval from dual;
3506:
3507: BEGIN
3508:
3509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3830: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

3826:
3827:
3828: -- Get the Group_id to be used for WIP Mass Load,
3829:
3830: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
3831:
3832: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3833:
3834: l_job_details_rec.group_id := l_job_header_rec.group_id;

Line 3929: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;

3925: -- l_job_details_rec.quantity_per_assembly := l_required_quantity / p_ro_quantity;
3926:
3927: -- Get the Group_id to be used for WIP Mass Load,
3928:
3929: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;
3930:
3931: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3932:
3933: -- l_job_details_rec.group_id := l_job_header_rec.group_id;

Line 4370: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

4366: end if;
4367:
4368:
4369: -- Get the Group_id to be used for WIP Mass Load,
4370: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
4371:
4372:
4373: -- get job_quantity
4374: open get_job_quantity ( p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id);

Line 4779: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

4775: If p_res_txn_dtls_tbl(res_ctr).new_row = 'Y' then
4776:
4777: -- Get the Group_id to be used for WIP Mass Load,
4778:
4779: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
4780:
4781: -- get job_quantity
4782: open get_job_quantity ( p_res_txn_dtls_tbl(res_ctr).wip_entity_id);
4783: fetch get_job_quantity into l_job_quantity;

Line 5149: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

5145:
5146: IF p_op_dtls_tbl(op_ctr).operation_seq_num is not null THEN
5147: -- Get the Group_id to be used for WIP Mass Load,
5148:
5149: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5150:
5151: -- set job header info
5152: l_job_header_rec.header_id := l_job_header_rec.group_id;
5153: l_job_header_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;

Line 5624: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

5620:
5621:
5622: -- Get the Group_id to be used for WIP Create Job,
5623:
5624: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5625:
5626: l_job_header_rec.interface_id := l_job_header_rec.group_id;
5627:
5628: generate_job_name ( p_job_prefix =>l_job_prefix,

Line 6294: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

6290: -- table. This is passed to the insert_job_header
6291: -- procedure
6292:
6293: -- Get the Group_id to be used for WIP Create Job,
6294: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
6295:
6296: l_job_header_rec.interface_id := l_job_header_rec.group_id;
6297: l_job_header_rec.bom_reference_id := bills_routes_rec.bom_reference_id ;
6298: l_job_header_rec.routing_reference_id := bills_routes_rec.routing_reference_id ;