APPS.OE_RETROBILL_PVT dependencies on QP_LDETS_V

Line 2280: FROM QP_LDETS_v ldets

2276: --bug3654144 Multiplying by -1 if the line_category_code = 'ORDER'
2277: , (oepj.adjusted_amount_per_pqty - ldets.adjustment_amount) * decode(oeol.line_category_code, 'RETURN', 1, -1)
2278: , 1
2279: ,null --this offset adjustment should not have retrobill request id
2280: FROM QP_LDETS_v ldets
2281: , QP_PREQ_LINES_TMP lines
2282: , QP_LIST_HEADERS_B QH
2283: , OE_PRICE_ADJUSTMENTS oepj
2284: , OE_ORDER_LINES_ALL oeol

Line 2321: From QP_LDETS_V ldets

2317: =(SELECT oepj.adjusted_amount - ldets.adjustment_amount* nvl(lines.priced_quantity,1/nvl(lines.line_quantity,1))
2318: ,oepj.adjusted_amount_per_pqty - ldets.adjustment_amount
2319: adjusted_amount - ldets.adjustment_amount* nvl(lines.priced_quantity,1/nvl(lines.line_quantity,1))
2320: adjusted_amont_per_pqty - ldets.adjustment_amount
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

Line 2405: QP_LDETS_v ldets

2401: , ldets.proration_type_code
2402: , ldets.include_on_returns_flag
2403: , adj.lock_control + 1
2404: from
2405: QP_LDETS_v ldets
2406: , QP_PREQ_LINES_TMP lines
2407: WHERE
2408: lines.line_index = ldets.line_index
2409: --and lines.process_status <> 'NOT_VALID'

Line 2420: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2

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

Line 2652: QP_LDETS_v ldets

2648: , ldets.adjustment_amount
2649: , 1
2650: , G_CURRENT_RETROBILL_REQUEST_ID
2651: FROM
2652: QP_LDETS_v ldets
2653: , QP_PREQ_LINES_TMP lines
2654: , QP_LIST_HEADERS_B QH
2655: WHERE
2656: ldets.list_header_id=qh.list_header_id

Line 2944: QP_LDETS_v ldets

2940: , decode(oeol.line_category_code, 'RETURN', -1, 1) * ldets.adjustment_amount
2941: , 1
2942: , null --retrobill_request_id
2943: FROM
2944: QP_LDETS_v ldets
2945: , QP_PREQ_LINES_TMP lines
2946: , QP_LIST_HEADERS_B QH
2947: , OE_ORDER_LINES_ALL oeol
2948: WHERE

Line 2993: QP_LDETS_v ldets

2989: FROM oe_price_adjustments adj
2990: WHERE adj.list_line_id NOT IN
2991: (SELECT list_line_id
2992: FROM
2993: QP_LDETS_v ldets
2994: , QP_PREQ_LINES_TMP lines
2995: WHERE
2996: lines.line_index = ldets.line_index
2997: and lines.line_id= adj.line_id