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.QP_PREQ_GRP dependencies on QP_PRICING_PHASES

Line 37354: FROM QP_PRICING_PHASES

37350: INDX,QP_PREQ_GRP.get_price_list_sequence.cur_get_price_list_sequence,- No Index Used -,NA,NA
37351: */
37352: SELECT PHASE_SEQUENCE,PRICING_PHASE_ID
37353: INTO G_PRICE_LIST_SEQUENCE,G_PRICE_LIST_PHASE_ID
37354: FROM QP_PRICING_PHASES
37355: WHERE LIST_TYPE_CODE = 'PRL'
37356: AND ROWNUM < 2;
37357:
37358: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 40718: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1

40714: l_gone_in_phase_cur_loop varchar2(1); -- bug 3963888
40715: /*
40716: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
40717:
40718: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
40719: */
40720: --ignore_pricing start smbalara 8203956
40721: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
40722: l_price_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 40759: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40755: QPP.NAME,
40756: --QPEP.PRICING_EVENT_CODE
40757: nvl(QPEP.pattern_search_path,nvl(QPP.pattern_search_path,G_PAT_SEARCH_PATH)) pattern_search_path,
40758: DECODE(nvl(QPEP.pattern_search_path,nvl(QPP.pattern_search_path,G_PAT_SEARCH_PATH)),1,'Search Headers First','Search Lines First') pattern_search_path_desc
40759: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40760: WHERE ((L_MANUAL_ADJUSTMENTS_CALL_FLAG IS NULL)
40761: OR
40762: (L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'N' AND
40763: NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('A', 'B'))

Line 40790: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

40786: WHERE rownum < 7)
40787: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40788: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40789: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID
40790: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
40791: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
40792: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
40793: ORDER BY 5,3 DESC;
40794:

Line 40804: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40800: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40801: QPP.PHASE_SEQUENCE,
40802: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40803: --QPEP.PRICING_EVENT_CODE
40804: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40805: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'N'
40806: AND NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('A', 'B')
40807: AND QPEP.PRICING_EVENT_CODE IN
40808: (SELECT decode(rownum

Line 40825: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

40821: WHERE rownum < 7)
40822: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40823: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40824: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID
40825: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
40826: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
40827: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
40828: UNION
40829: SELECT QPP.PRICING_PHASE_ID,

Line 40836: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40832: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40833: QPP.PHASE_SEQUENCE,
40834: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40835: --QPEP.PRICING_EVENT_CODE
40836: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40837: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'Y'
40838: AND L_RETURN_MANUAL_DISCOUNT = 'N'
40839: AND NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('M', 'B')
40840: AND QPEP.PRICING_EVENT_CODE IN

Line 40858: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

40854: WHERE rownum < 7)
40855: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40856: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40857: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID
40858: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
40859: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
40860: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
40861: UNION
40862: SELECT QPP.PRICING_PHASE_ID,

Line 40869: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40865: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40866: QPP.PHASE_SEQUENCE,
40867: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40868: --QPEP.PRICING_EVENT_CODE
40869: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40870: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'Y'
40871: AND L_RETURN_MANUAL_DISCOUNT = 'Y'
40872: AND QPEP.PRICING_EVENT_CODE IN
40873: (SELECT decode(rownum

Line 40890: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

40886: WHERE rownum < 7)
40887: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40888: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40889: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID
40890: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
40891: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
40892: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))*/
40893:
40894: /* CURSOR l_phase_cur(l_event_code VARCHAR2,

Line 40903: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40899: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40900: QPP.PHASE_SEQUENCE,
40901: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40902: --QPEP.PRICING_EVENT_CODE
40903: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40904: WHERE QPEP.PRICING_EVENT_CODE IN
40905: (SELECT decode(rownum
40906: ,1 ,substr(l_event_code,1,instr(l_event_code1,',',1,1)-1)
40907: ,2 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,

Line 40922: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

40918: WHERE rownum < 7)
40919: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40920: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40921: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID
40922: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
40923: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
40924: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
40925: ORDER BY QPP.PHASE_SEQUENCE,SEARCH_FLAG DESC; */
40926:

Line 41044: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1

41040: LINE_DETAIL_INDEX
41041: FROM qp_npreq_line_attrs_tmp;
41042:
41043: /*
41044: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
41045:
41046: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
41047: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
41048: */

Line 41051: FROM qp_event_phases a , qp_pricing_phases b

41047: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
41048: */
41049: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
41050: SELECT b.pricing_phase_id,b.freeze_override_flag
41051: FROM qp_event_phases a , qp_pricing_phases b
41052: WHERE a.pricing_event_code in (SELECT decode(rownum
41053: ,1 ,substr(l_event_code,1,instr(l_event_code1,',',1,1)-1)
41054: ,2 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
41055: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))