DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on QP_LIST_HEADERS_B

Line 2282: , QP_LIST_HEADERS_B QH

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

Line 2654: , QP_LIST_HEADERS_B QH

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
2658: 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 2946: , QP_LIST_HEADERS_B QH

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