eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QLTCPPLB dependencies on QA_CHARS

Line 229: qa_chars qc

225: qpc.default_value_id,
226: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision ,
227: nvl(qpc.uom_code, qc.uom_code) uom_code
228: FROM qa_plan_chars qpc,
229: qa_chars qc
230: WHERE qpc.plan_id = X_COPY_PLAN_ID
231: AND qc.char_id = qpc.char_id
232: AND qc.char_id not in
233: (SELECT char_id

Line 296: FROM QA_PLAN_CHARS QPC, QA_CHARS QC

292:
293: -- -- Bug 4958761. SQL Repository Fix SQL ID: 15008205
294: CURSOR C7 IS
295: SELECT TO_NUMBER(SUBSTR(QPC.RESULT_COLUMN_NAME,10,3)) RES_COLUMN_NAME
296: FROM QA_PLAN_CHARS QPC, QA_CHARS QC
297: WHERE PLAN_ID = X_PLAN_ID
298: AND qc.char_id = qpc.char_id
299: AND QC.HARDCODED_COLUMN IS NULL
300: AND QC.DATATYPE in (1,2,3,6)

Line 327: FROM QA_PLAN_CHARS QPC, QA_CHARS QC

323:
324: -- Bug 4958761. SQL Repository Fix SQL ID: 15008222
325: CURSOR C8 IS
326: SELECT TO_NUMBER(SUBSTR(RESULT_COLUMN_NAME,8,3)) RES_COLUMN_NAME
327: FROM QA_PLAN_CHARS QPC, QA_CHARS QC
328: WHERE QPC.PLAN_ID = X_PLAN_ID
329: and qc.char_id = qpc.char_id
330: AND QC.HARDCODED_COLUMN IS NULL
331: AND QC.DATATYPE = 4