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.QLTAUFLB dependencies on QA_SS_CONST

Line 634: p_id_list => qa_ss_const.QUANTITY || ',' ||

630: -- Bug 4958757 SQL Repository tuning.
631: l_key := 'QLTAUFLB.C_MOBILE_INSPECT';
632: qa_performance_temp_pkg.purge_and_add_ids(
633: p_key => l_key,
634: p_id_list => qa_ss_const.QUANTITY || ',' ||
635: qa_ss_const.INSPECTION_RESULT || ',' ||
636: qa_ss_const.ITEM || ',' ||
637: qa_ss_const.UOM);
638:

Line 635: qa_ss_const.INSPECTION_RESULT || ',' ||

631: l_key := 'QLTAUFLB.C_MOBILE_INSPECT';
632: qa_performance_temp_pkg.purge_and_add_ids(
633: p_key => l_key,
634: p_id_list => qa_ss_const.QUANTITY || ',' ||
635: qa_ss_const.INSPECTION_RESULT || ',' ||
636: qa_ss_const.ITEM || ',' ||
637: qa_ss_const.UOM);
638:
639: OPEN c_plan_chars(x_copy_plan_id, x_plan_id, l_key);

Line 636: qa_ss_const.ITEM || ',' ||

632: qa_performance_temp_pkg.purge_and_add_ids(
633: p_key => l_key,
634: p_id_list => qa_ss_const.QUANTITY || ',' ||
635: qa_ss_const.INSPECTION_RESULT || ',' ||
636: qa_ss_const.ITEM || ',' ||
637: qa_ss_const.UOM);
638:
639: OPEN c_plan_chars(x_copy_plan_id, x_plan_id, l_key);
640: LOOP

Line 637: qa_ss_const.UOM);

633: p_key => l_key,
634: p_id_list => qa_ss_const.QUANTITY || ',' ||
635: qa_ss_const.INSPECTION_RESULT || ',' ||
636: qa_ss_const.ITEM || ',' ||
637: qa_ss_const.UOM);
638:
639: OPEN c_plan_chars(x_copy_plan_id, x_plan_id, l_key);
640: LOOP
641:

Line 784: p_id_list => qa_ss_const.TRANSACTION_DATE || ',' ||

780: -- Bug 4958757 SQL Repository tuning.
781: l_key := 'QLTAUFLB.C5';
782: qa_performance_temp_pkg.purge_and_add_ids(
783: p_key => l_key,
784: p_id_list => qa_ss_const.TRANSACTION_DATE || ',' ||
785: qa_ss_const.QUANTITY || ',' ||
786: qa_ss_const.INSPECTION_RESULT || ',' ||
787: qa_ss_const.UOM_NAME);
788:

Line 785: qa_ss_const.QUANTITY || ',' ||

781: l_key := 'QLTAUFLB.C5';
782: qa_performance_temp_pkg.purge_and_add_ids(
783: p_key => l_key,
784: p_id_list => qa_ss_const.TRANSACTION_DATE || ',' ||
785: qa_ss_const.QUANTITY || ',' ||
786: qa_ss_const.INSPECTION_RESULT || ',' ||
787: qa_ss_const.UOM_NAME);
788:
789: OPEN c_plan_chars(x_copy_plan_id, x_plan_id, l_key);

Line 786: qa_ss_const.INSPECTION_RESULT || ',' ||

782: qa_performance_temp_pkg.purge_and_add_ids(
783: p_key => l_key,
784: p_id_list => qa_ss_const.TRANSACTION_DATE || ',' ||
785: qa_ss_const.QUANTITY || ',' ||
786: qa_ss_const.INSPECTION_RESULT || ',' ||
787: qa_ss_const.UOM_NAME);
788:
789: OPEN c_plan_chars(x_copy_plan_id, x_plan_id, l_key);
790: LOOP

Line 787: qa_ss_const.UOM_NAME);

783: p_key => l_key,
784: p_id_list => qa_ss_const.TRANSACTION_DATE || ',' ||
785: qa_ss_const.QUANTITY || ',' ||
786: qa_ss_const.INSPECTION_RESULT || ',' ||
787: qa_ss_const.UOM_NAME);
788:
789: OPEN c_plan_chars(x_copy_plan_id, x_plan_id, l_key);
790: LOOP
791:

Line 993: p_id_list => qa_ss_const.VENDOR_NAME || ',' ||

989: -- Bug 4958757 SQL Repository tuning.
990: l_key := 'QLTAUFLB.C1';
991: qa_performance_temp_pkg.purge_and_add_ids(
992: p_key => l_key,
993: p_id_list => qa_ss_const.VENDOR_NAME || ',' ||
994: qa_ss_const.PO_NUMBER);
995:
996: OPEN c_plan_chars(7, p_plan_id, l_key); -- 7 is OSP Template Plan ID.
997: LOOP

Line 994: qa_ss_const.PO_NUMBER);

990: l_key := 'QLTAUFLB.C1';
991: qa_performance_temp_pkg.purge_and_add_ids(
992: p_key => l_key,
993: p_id_list => qa_ss_const.VENDOR_NAME || ',' ||
994: qa_ss_const.PO_NUMBER);
995:
996: OPEN c_plan_chars(7, p_plan_id, l_key); -- 7 is OSP Template Plan ID.
997: LOOP
998: FETCH c_plan_chars INTO qpcv;