APPS.OE_RETROBILL_PVT dependencies on QP_PREQ_LINES_TMP

Line 1748: from qp_preq_lines_tmp lines,

1744: , l.inventory_item_id --For identifying unique item
1745: , l.sold_to_org_id --For identifying unique customer
1746: , l.line_number
1747: , l.lock_control + 1 LOCK_CONTROL
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);

Line 2281: , QP_PREQ_LINES_TMP lines

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
2285: WHERE

Line 2406: , QP_PREQ_LINES_TMP lines

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'
2410: and ldets.list_line_id = adj.list_line_id

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 2653: , QP_PREQ_LINES_TMP lines

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
2657: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 2945: , QP_PREQ_LINES_TMP lines

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
2949: ldets.list_header_id=qh.list_header_id

Line 2994: , QP_PREQ_LINES_TMP lines

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
2998: and adj.list_line_id=ldets.list_line_id)