APPS.OE_RETROBILL_PVT dependencies on QP_PREQ_LINES_TMP

Line 1444: from qp_preq_lines_tmp lines,

1440: , l.inventory_item_id --For identifying unique item
1441: , l.sold_to_org_id --For identifying unique customer
1442: , l.line_number
1443: , l.lock_control + 1 LOCK_CONTROL
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);

Line 1943: , QP_PREQ_LINES_TMP lines

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

Line 2068: , QP_PREQ_LINES_TMP lines

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

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

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

Line 2607: , QP_PREQ_LINES_TMP lines

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

Line 2656: , QP_PREQ_LINES_TMP lines

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