DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on DUAL

Line 171: FROM DUAL;

167: l_source_code VARCHAR2(30);
168:
169: CURSOR group_cur IS
170: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
171: FROM DUAL;
172:
173: -- Bug 3019869. Changed the below cursor to wip_job cursor.
174: -- Records will not reside in WJSI if the MRP Debug mode
175: -- profile option is set to 'No'. kabalakr

Line 613: FROM DUAL;

609: l_txn_date DATE;
610:
611: CURSOR txn_cur IS
612: SELECT wip_transactions_s.nextval
613: FROM DUAL;
614:
615: CURSOR req_cur IS
616: SELECT request_id
617: FROM FND_CONC_REQ_SUMMARY_V

Line 2547: FROM DUAL;

2543: l_txn_date DATE;
2544:
2545: CURSOR txn_cur IS
2546: SELECT wip_transactions_s.nextval
2547: FROM DUAL;
2548:
2549: CURSOR req_cur IS
2550: SELECT request_id
2551: FROM FND_CONC_REQ_SUMMARY_V

Line 2902: FROM DUAL;

2898:
2899:
2900: CURSOR group_cur IS
2901: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
2902: FROM DUAL;
2903:
2904: CURSOR job_cur IS
2905: SELECT wip_entity_id
2906: FROM wip_entities

Line 3823: FROM DUAL;

3819:
3820: /*
3821: CURSOR txn_head_seq IS
3822: SELECT mtl_material_transactions_s.nextval
3823: FROM DUAL;
3824: */
3825:
3826: -- We are not translating the Action_Fired value.
3827: -- Hence commenting the below cursor.

Line 4084: from dual

4080: sql_string :=
4081: 'select code
4082: from
4083: (select ''x'' code, ''x'' description
4084: from dual
4085: where 1 = 2
4086: union
4087: select * from
4088: ( '|| sql_string ||