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

Line 1448: and lines.pricing_status_code in(QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION);

1444: from qp_preq_lines_tmp lines,
1445: oe_order_lines_all l
1446: where lines.line_id=l.line_id
1447: and lines.line_type_code='LINE'
1448: and lines.pricing_status_code in(QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION);
1449:
1450: cursor get_retrobilled_sum(p_order_source_id IN NUMBER,
1451: p_orig_sys_document_ref IN NUMBER,
1452: p_orig_sys_line_ref IN NUMBER,

Line 1949: --AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

1945: , OE_PRICE_ADJUSTMENTS oepj
1946: , OE_ORDER_LINES_ALL oeol
1947: WHERE
1948: ldets.list_header_id=qh.list_header_id
1949: --AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
1950: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1951: --AND lines.process_status <> 'NOT_VALID'
1952: AND ldets.line_index=lines.line_index
1953: AND oepj.line_id=oeol.line_id

Line 1950: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

1946: , OE_ORDER_LINES_ALL oeol
1947: WHERE
1948: ldets.list_header_id=qh.list_header_id
1949: --AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
1950: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1951: --AND lines.process_status <> 'NOT_VALID'
1952: AND ldets.line_index=lines.line_index
1953: AND oepj.line_id=oeol.line_id
1954: --AND (nvl(ldets.automatic_flag,'N') = 'Y')

Line 1987: --AND ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED

1983: From QP_LDETS_V ldets
1984: Where ldets.list_line_id = oepj.list_line_id
1985: --AND ldets.price_adjustment_id = oepj.price_adjustment_id
1986: AND oepj.retrobill_request_id = G_CURRENT_RETROBILL_REQUEST_ID
1987: --AND ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED
1988: )
1989: WHERE retrobill_request_id IS NULL --offset adj does not have retrobill_request_id
1990: AND */
1991: null;

Line 2076: --and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED

2072: and ldets.list_line_id = adj.list_line_id
2073: --bug3417428
2074: --and ldets.line_index = adj.header_id+nvl(adj.line_id,0)
2075: and lines.line_id=adj.line_id
2076: --and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED
2077: and adj.retrobill_request_id = G_CURRENT_RETROBILL_REQUEST_ID
2078: )
2079: WHERE header_id=oe_order_pub.g_hdr.header_id
2080: and list_line_id in

Line 2084: --and ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED

2080: and list_line_id in
2081: (select list_line_id
2082: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
2083: where --lines2.process_status <> 'NOT_VALID'
2084: --and ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
2085: lines2.line_index = ldets2.line_index
2086: and ldets2.list_line_id = adj.list_line_id
2087: --bug3417428
2088: --and ldets2.line_index = adj.header_id+nvl(adj.line_id,0))

Line 2319: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

2315: , QP_PREQ_LINES_TMP lines
2316: , QP_LIST_HEADERS_B QH
2317: WHERE
2318: ldets.list_header_id=qh.list_header_id
2319: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2320: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2321: AND lines.process_status <> 'NOT_VALID'
2322: AND ldets.line_index=lines.line_index
2323: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2320: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

2316: , QP_LIST_HEADERS_B QH
2317: WHERE
2318: ldets.list_header_id=qh.list_header_id
2319: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2320: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2321: AND lines.process_status <> 'NOT_VALID'
2322: AND ldets.line_index=lines.line_index
2323: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2324: AND (nvl(ldets.automatic_flag,'N') = 'Y')

Line 2323: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2319: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2320: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2321: AND lines.process_status <> 'NOT_VALID'
2322: AND ldets.line_index=lines.line_index
2323: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2324: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2325: -- or
2326: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
2327: AND ldets.created_from_list_type_code not in ('PRL','AGR')

Line 2612: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

2608: , QP_LIST_HEADERS_B QH
2609: , OE_ORDER_LINES_ALL oeol
2610: WHERE
2611: ldets.list_header_id=qh.list_header_id
2612: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2613: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2614: AND lines.process_status <> 'NOT_VALID'
2615: AND ldets.line_index=lines.line_index
2616: AND lines.line_id=oeol.line_id

Line 2613: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

2609: , OE_ORDER_LINES_ALL oeol
2610: WHERE
2611: ldets.list_header_id=qh.list_header_id
2612: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2613: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2614: AND lines.process_status <> 'NOT_VALID'
2615: AND ldets.line_index=lines.line_index
2616: AND lines.line_id=oeol.line_id
2617: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2617: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2613: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2614: AND lines.process_status <> 'NOT_VALID'
2615: AND ldets.line_index=lines.line_index
2616: AND lines.line_id=oeol.line_id
2617: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2618: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2619: -- or
2620: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
2621: AND ldets.created_from_list_type_code not in ('PRL','AGR')

Line 2817: l_price_control_rec QP_PREQ_GRP.control_record_type;

2813: SELECT line_id
2814: FROM oe_order_lines_all
2815: WHERE header_id=p_header_id;
2816:
2817: l_price_control_rec QP_PREQ_GRP.control_record_type;
2818: --bug5003256
2819: l_book_line_count NUMBER;
2820: Begin
2821:

Line 2959: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

2955:
2956: END LOOP;
2957: ELSIF p_execution_mode = 'PREVIEW' THEN --preview again, reprice the order
2958: l_Price_Control_Rec.pricing_event := 'RETROBILL';
2959: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
2960: l_Price_Control_Rec.Simulation_Flag := 'N';
2961:
2962: --bug3738043 start
2963: --reinitializing G_RETRO_PRICING_PHASE_COUNT when previewed again