APPS.QLTTRAWB dependencies on QA_SPECS

Line 5123: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the

5119:
5120: -- group validation for spec_name
5121:
5122: --
5123: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5124: -- subquery. It uses too much shared memory. Replaced with
5125: -- QA_SPECS and appended the effective date validation.
5126: -- bso Mon Nov 25 18:15:12 PST 2002
5127: --

Line 5125: -- QA_SPECS and appended the effective date validation.

5121:
5122: --
5123: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5124: -- subquery. It uses too much shared memory. Replaced with
5125: -- QA_SPECS and appended the effective date validation.
5126: -- bso Mon Nov 25 18:15:12 PST 2002
5127: --
5128: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5129: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 5150: FROM QA_SPECS QSVV

5146: AND QIE.ERROR_COLUMN IN ('SPEC_NAME', NULL))
5147: AND (QRI.SPEC_NAME IS NOT NULL
5148: AND NOT EXISTS
5149: (SELECT 'X'
5150: FROM QA_SPECS QSVV
5151: WHERE QRI.SPEC_NAME = QSVV.SPEC_NAME
5152: AND QRI.ORGANIZATION_ID = QSVV.ORGANIZATION_ID
5153: AND trunc(sysdate) BETWEEN
5154: nvl(trunc(qsvv.effective_from), trunc(sysdate)) AND

Line 5160: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the

5156:
5157: -- group derivation for spec_id
5158:
5159: --
5160: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5161: -- subquery. It uses too much shared memory. Replaced with
5162: -- QA_SPECS and appended the effective date validation.
5163: -- bso Mon Nov 25 18:15:12 PST 2002
5164: --

Line 5162: -- QA_SPECS and appended the effective date validation.

5158:
5159: --
5160: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5161: -- subquery. It uses too much shared memory. Replaced with
5162: -- QA_SPECS and appended the effective date validation.
5163: -- bso Mon Nov 25 18:15:12 PST 2002
5164: --
5165: UPDATE QA_RESULTS_INTERFACE QRI
5166: SET LAST_UPDATE_DATE = SYSDATE,

Line 5174: FROM QA_SPECS QSVV

5170: PROGRAM_ID = X_PROGRAM_ID,
5171: PROGRAM_UPDATE_DATE = SYSDATE,
5172: SPEC_ID =
5173: (SELECT MIN(QSVV.SPEC_ID)
5174: FROM QA_SPECS QSVV
5175: WHERE QSVV.SPEC_NAME = QRI.SPEC_NAME
5176: AND QSVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID
5177: AND trunc(sysdate) BETWEEN
5178: nvl(trunc(qsvv.effective_from), trunc(sysdate)) AND

Line 7748: FROM QA_SPECS QSVV

7744: AND QP.ORGANIZATION_ID = QRI.ORGANIZATION_ID),
7745: -- spec_id
7746: SPEC_ID =
7747: (SELECT MIN(QSVV.SPEC_ID)
7748: FROM QA_SPECS QSVV
7749: WHERE QSVV.SPEC_NAME = QRI.SPEC_NAME
7750: AND QSVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID
7751: AND trunc(sysdate) BETWEEN
7752: nvl(trunc(qsvv.effective_from), trunc(sysdate)) AND