DBA Data[Home] [Help]

APPS.QP_COPY_DEBUG_PVT dependencies on QP_INT_LINES

Line 817: FROM qp_int_lines

813: LINE_CATEGORY,
814: CONTRACT_START_DATE,
815: CONTRACT_END_DATE,
816: NULL -- sfiresto 2374448
817: FROM qp_int_lines
818: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
819: --added by yangli for Java Engine 3086881
820: ORDER BY line_index;
821:

Line 1111: SELECT LINE_ID FROM qp_int_lines

1107: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1108: AND LINE_TYPE_CODE = 'ORDER'
1109: AND ROWNUM = 1
1110: UNION ALL
1111: SELECT LINE_ID FROM qp_int_lines
1112: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1113: AND LINE_TYPE_CODE = 'ORDER'
1114: AND ROWNUM = 1;
1115:

Line 1121: SELECT REQUEST_TYPE_CODE FROM qp_int_lines

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
1122: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1123: AND ROWNUM = 1;
1124:
1125: CURSOR CURRENCY_CODE_CUR IS

Line 1130: SELECT CURRENCY_CODE FROM qp_int_lines

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
1131: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1132: AND ROWNUM = 1;
1133:
1134: CURSOR LINE_ATTR_ID_CUR is