APPS.OE_RETROBILL_PVT dependencies on QP_LDETS_V

Line 1942: FROM QP_LDETS_v ldets

1938: --bug3654144 Multiplying by -1 if the line_category_code = 'ORDER'
1939: , (oepj.adjusted_amount_per_pqty - ldets.adjustment_amount) * decode(oeol.line_category_code, 'RETURN', 1, -1)
1940: , 1
1941: ,null --this offset adjustment should not have retrobill request id
1942: FROM QP_LDETS_v ldets
1943: , QP_PREQ_LINES_TMP lines
1944: , QP_LIST_HEADERS_B QH
1945: , OE_PRICE_ADJUSTMENTS oepj
1946: , OE_ORDER_LINES_ALL oeol

Line 1983: From QP_LDETS_V ldets

1979: =(SELECT oepj.adjusted_amount - ldets.adjustment_amount* nvl(lines.priced_quantity,1/nvl(lines.line_quantity,1))
1980: ,oepj.adjusted_amount_per_pqty - ldets.adjustment_amount
1981: adjusted_amount - ldets.adjustment_amount* nvl(lines.priced_quantity,1/nvl(lines.line_quantity,1))
1982: adjusted_amont_per_pqty - ldets.adjustment_amount
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

Line 2067: QP_LDETS_v ldets

2063: , ldets.proration_type_code
2064: , ldets.include_on_returns_flag
2065: , adj.lock_control + 1
2066: from
2067: QP_LDETS_v ldets
2068: , QP_PREQ_LINES_TMP lines
2069: WHERE
2070: lines.line_index = ldets.line_index
2071: --and lines.process_status <> 'NOT_VALID'

Line 2082: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2

2078: )
2079: WHERE header_id=oe_order_pub.g_hdr.header_id
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

Line 2314: QP_LDETS_v ldets

2310: , ldets.adjustment_amount
2311: , 1
2312: , G_CURRENT_RETROBILL_REQUEST_ID
2313: FROM
2314: QP_LDETS_v ldets
2315: , QP_PREQ_LINES_TMP lines
2316: , QP_LIST_HEADERS_B QH
2317: WHERE
2318: ldets.list_header_id=qh.list_header_id

Line 2606: QP_LDETS_v ldets

2602: , decode(oeol.line_category_code, 'RETURN', -1, 1) * ldets.adjustment_amount
2603: , 1
2604: , null --retrobill_request_id
2605: FROM
2606: QP_LDETS_v ldets
2607: , QP_PREQ_LINES_TMP lines
2608: , QP_LIST_HEADERS_B QH
2609: , OE_ORDER_LINES_ALL oeol
2610: WHERE

Line 2655: QP_LDETS_v ldets

2651: FROM oe_price_adjustments adj
2652: WHERE adj.list_line_id NOT IN
2653: (SELECT list_line_id
2654: FROM
2655: QP_LDETS_v ldets
2656: , QP_PREQ_LINES_TMP lines
2657: WHERE
2658: lines.line_index = ldets.line_index
2659: and lines.line_id= adj.line_id