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.

[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on QP_PREQ_GRP

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

1748: from qp_preq_lines_tmp lines,
1749: oe_order_lines_all l
1750: where lines.line_id=l.line_id
1751: and lines.line_type_code='LINE'
1752: and lines.pricing_status_code in(QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION);
1753:
1754: cursor get_retrobilled_sum(p_order_source_id IN NUMBER,
1755: p_orig_sys_document_ref IN NUMBER,
1756: p_orig_sys_line_ref IN NUMBER,

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

2283: , OE_PRICE_ADJUSTMENTS oepj
2284: , OE_ORDER_LINES_ALL oeol
2285: WHERE
2286: ldets.list_header_id=qh.list_header_id
2287: --AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2288: 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)
2289: --AND lines.process_status <> 'NOT_VALID'
2290: AND ldets.line_index=lines.line_index
2291: AND oepj.line_id=oeol.line_id

Line 2288: 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)

2284: , OE_ORDER_LINES_ALL oeol
2285: WHERE
2286: ldets.list_header_id=qh.list_header_id
2287: --AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2288: 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)
2289: --AND lines.process_status <> 'NOT_VALID'
2290: AND ldets.line_index=lines.line_index
2291: AND oepj.line_id=oeol.line_id
2292: --AND (nvl(ldets.automatic_flag,'N') = 'Y')

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

2321: From QP_LDETS_V ldets
2322: Where ldets.list_line_id = oepj.list_line_id
2323: --AND ldets.price_adjustment_id = oepj.price_adjustment_id
2324: AND oepj.retrobill_request_id = G_CURRENT_RETROBILL_REQUEST_ID
2325: --AND ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED
2326: )
2327: WHERE retrobill_request_id IS NULL --offset adj does not have retrobill_request_id
2328: AND */
2329: null;

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

2410: and ldets.list_line_id = adj.list_line_id
2411: --bug3417428
2412: --and ldets.line_index = adj.header_id+nvl(adj.line_id,0)
2413: and lines.line_id=adj.line_id
2414: --and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED
2415: and adj.retrobill_request_id = G_CURRENT_RETROBILL_REQUEST_ID
2416: )
2417: WHERE header_id=oe_order_pub.g_hdr.header_id
2418: and list_line_id in

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

2418: and list_line_id in
2419: (select list_line_id
2420: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
2421: where --lines2.process_status <> 'NOT_VALID'
2422: --and ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
2423: lines2.line_index = ldets2.line_index
2424: and ldets2.list_line_id = adj.list_line_id
2425: --bug3417428
2426: --and ldets2.line_index = adj.header_id+nvl(adj.line_id,0))

Line 2657: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

2653: , QP_PREQ_LINES_TMP lines
2654: , QP_LIST_HEADERS_B QH
2655: WHERE
2656: ldets.list_header_id=qh.list_header_id
2657: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2658: 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)
2659: AND lines.process_status <> 'NOT_VALID'
2660: AND ldets.line_index=lines.line_index
2661: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2658: 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)

2654: , QP_LIST_HEADERS_B QH
2655: WHERE
2656: ldets.list_header_id=qh.list_header_id
2657: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2658: 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)
2659: AND lines.process_status <> 'NOT_VALID'
2660: AND ldets.line_index=lines.line_index
2661: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2662: AND (nvl(ldets.automatic_flag,'N') = 'Y')

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

2657: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2658: 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)
2659: AND lines.process_status <> 'NOT_VALID'
2660: AND ldets.line_index=lines.line_index
2661: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2662: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2663: -- or
2664: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
2665: AND ldets.created_from_list_type_code not in ('PRL','AGR')

Line 2950: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

2946: , QP_LIST_HEADERS_B QH
2947: , OE_ORDER_LINES_ALL oeol
2948: WHERE
2949: ldets.list_header_id=qh.list_header_id
2950: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2951: 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)
2952: AND lines.process_status <> 'NOT_VALID'
2953: AND ldets.line_index=lines.line_index
2954: AND lines.line_id=oeol.line_id

Line 2951: 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)

2947: , OE_ORDER_LINES_ALL oeol
2948: WHERE
2949: ldets.list_header_id=qh.list_header_id
2950: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2951: 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)
2952: AND lines.process_status <> 'NOT_VALID'
2953: AND ldets.line_index=lines.line_index
2954: AND lines.line_id=oeol.line_id
2955: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

2951: 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)
2952: AND lines.process_status <> 'NOT_VALID'
2953: AND ldets.line_index=lines.line_index
2954: AND lines.line_id=oeol.line_id
2955: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2956: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2957: -- or
2958: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
2959: AND ldets.created_from_list_type_code not in ('PRL','AGR')

Line 3155: l_price_control_rec QP_PREQ_GRP.control_record_type;

3151: SELECT line_id
3152: FROM oe_order_lines_all
3153: WHERE header_id=p_header_id;
3154:
3155: l_price_control_rec QP_PREQ_GRP.control_record_type;
3156: --bug5003256
3157: l_book_line_count NUMBER;
3158: Begin
3159:

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

3293:
3294: END LOOP;
3295: ELSIF p_execution_mode = 'PREVIEW' THEN --preview again, reprice the order
3296: l_Price_Control_Rec.pricing_event := 'RETROBILL';
3297: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
3298: l_Price_Control_Rec.Simulation_Flag := 'N';
3299:
3300: --bug3738043 start
3301: --reinitializing G_RETRO_PRICING_PHASE_COUNT when previewed again