DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_LIST_HEADERS_B

Line 550: , QP_LIST_HEADERS_B QH

546: , NULL
547: , 1
548: FROM
549: QP_LDETS_v ldets
550: , QP_LIST_HEADERS_B QH
551: WHERE
552: ldets.line_detail_index = i.line_detail_index
553: and ldets.list_header_id=qh.list_header_id
554: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 968: , QP_LIST_HEADERS_B QH

964: , NULL
965: , 1
966: FROM
967: QP_LDETS_v ldets
968: , QP_LIST_HEADERS_B QH
969: WHERE
970: ldets.line_detail_index = i.line_detail_index
971: and ldets.list_header_id=qh.list_header_id
972: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 1852: , QP_LIST_HEADERS_B QH

1848: proration_type_code, include_on_returns_flag,lines.line_index line_index
1849: from
1850: QP_LDETS_v ldets
1851: , QP_PREQ_LINES_TMP lines
1852: , QP_LIST_HEADERS_B QH
1853: where
1854: ldets.LIST_HEADER_ID = qh.list_header_id
1855: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED)
1856: 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 2421: , QP_LIST_HEADERS_B QH

2417: , 1
2418: FROM
2419: QP_LDETS_v ldets
2420: , QP_PREQ_LINES_TMP lines
2421: , QP_LIST_HEADERS_B QH
2422: WHERE
2423: ldets.list_header_id=qh.list_header_id
2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2425: 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)