APPS.QP_COPY_DEBUG_PVT dependencies on QP_NPREQ_LINES_TMP

Line 767: FROM qp_npreq_lines_tmp

763: LINE_CATEGORY,
764: CONTRACT_START_DATE,
765: CONTRACT_END_DATE,
766: NULL -- sfiresto 2374448
767: FROM qp_npreq_lines_tmp
768: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
769: --added by yangli for Java Engine 3086881
770: UNION ALL
771: SELECT REQUEST_TYPE_CODE,

Line 1106: SELECT LINE_ID FROM qp_npreq_lines_tmp

1102: -- CURSOR REQUEST_ID_CUR IS
1103: -- SELECT qp_debug_req_s.nextval FROM dual;
1104:
1105: CURSOR LINE_ID_CUR IS
1106: SELECT LINE_ID FROM qp_npreq_lines_tmp
1107: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1108: AND LINE_TYPE_CODE = 'ORDER'
1109: AND ROWNUM = 1
1110: UNION ALL

Line 1117: SELECT REQUEST_TYPE_CODE FROM qp_npreq_lines_tmp

1113: AND LINE_TYPE_CODE = 'ORDER'
1114: AND ROWNUM = 1;
1115:
1116: CURSOR REQUEST_TYPE_CODE_CUR IS
1117: SELECT REQUEST_TYPE_CODE FROM qp_npreq_lines_tmp
1118: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1119: AND ROWNUM = 1
1120: UNION ALL
1121: SELECT REQUEST_TYPE_CODE FROM qp_int_lines

Line 1126: SELECT CURRENCY_CODE FROM qp_npreq_lines_tmp

1122: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1123: AND ROWNUM = 1;
1124:
1125: CURSOR CURRENCY_CODE_CUR IS
1126: SELECT CURRENCY_CODE FROM qp_npreq_lines_tmp
1127: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1128: AND ROWNUM = 1
1129: UNION ALL
1130: SELECT CURRENCY_CODE FROM qp_int_lines