DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on QP_LIST_HEADERS_B

Line 1944: , QP_LIST_HEADERS_B QH

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

Line 2316: , QP_LIST_HEADERS_B QH

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
2320: 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)

Line 2608: , QP_LIST_HEADERS_B QH

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