APPS.QLTTRAWB dependencies on QA_SPECS

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

5471:
5472: -- group validation for spec_name
5473:
5474: --
5475: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5476: -- subquery. It uses too much shared memory. Replaced with
5477: -- QA_SPECS and appended the effective date validation.
5478: -- bso Mon Nov 25 18:15:12 PST 2002
5479: --

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

5473:
5474: --
5475: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5476: -- subquery. It uses too much shared memory. Replaced with
5477: -- QA_SPECS and appended the effective date validation.
5478: -- bso Mon Nov 25 18:15:12 PST 2002
5479: --
5480: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5481: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 5502: FROM QA_SPECS QSVV

5498: AND QIE.ERROR_COLUMN IN ('SPEC_NAME', NULL))
5499: AND (QRI.SPEC_NAME IS NOT NULL
5500: AND NOT EXISTS
5501: (SELECT 'X'
5502: FROM QA_SPECS QSVV
5503: WHERE QRI.SPEC_NAME = QSVV.SPEC_NAME
5504: AND QRI.ORGANIZATION_ID = QSVV.ORGANIZATION_ID
5505: AND trunc(sysdate) BETWEEN
5506: nvl(trunc(qsvv.effective_from), trunc(sysdate)) AND

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

5511: END IF;
5512: -- group derivation for spec_id
5513:
5514: --
5515: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5516: -- subquery. It uses too much shared memory. Replaced with
5517: -- QA_SPECS and appended the effective date validation.
5518: -- bso Mon Nov 25 18:15:12 PST 2002
5519: --

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

5513:
5514: --
5515: -- Bug 2672408. This SQL used to have QA_SPECS_VAL_V in the
5516: -- subquery. It uses too much shared memory. Replaced with
5517: -- QA_SPECS and appended the effective date validation.
5518: -- bso Mon Nov 25 18:15:12 PST 2002
5519: --
5520: UPDATE QA_RESULTS_INTERFACE QRI
5521: SET LAST_UPDATE_DATE = SYSDATE,

Line 5529: FROM QA_SPECS QSVV

5525: PROGRAM_ID = X_PROGRAM_ID,
5526: PROGRAM_UPDATE_DATE = SYSDATE,
5527: SPEC_ID =
5528: (SELECT MIN(QSVV.SPEC_ID)
5529: FROM QA_SPECS QSVV
5530: WHERE QSVV.SPEC_NAME = QRI.SPEC_NAME
5531: AND QSVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID
5532: AND trunc(sysdate) BETWEEN
5533: nvl(trunc(qsvv.effective_from), trunc(sysdate)) AND

Line 8264: FROM QA_SPECS QSVV

8260: AND QP.ORGANIZATION_ID = QRI.ORGANIZATION_ID),
8261: -- spec_id
8262: SPEC_ID =
8263: (SELECT MIN(QSVV.SPEC_ID)
8264: FROM QA_SPECS QSVV
8265: WHERE QSVV.SPEC_NAME = QRI.SPEC_NAME
8266: AND QSVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID
8267: AND trunc(sysdate) BETWEEN
8268: nvl(trunc(qsvv.effective_from), trunc(sysdate)) AND