DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_LIST_HEADERS_B

Line 618: , QP_LIST_HEADERS_B QH

614: , NULL
615: , 1
616: FROM
617: QP_LDETS_v ldets
618: , QP_LIST_HEADERS_B QH
619: WHERE
620: ldets.line_detail_index = i.line_detail_index
621: and ldets.list_header_id=qh.list_header_id
622: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 1253: , QP_LIST_HEADERS_B QH

1249: , NULL
1250: , 1
1251: FROM
1252: QP_LDETS_v ldets
1253: , QP_LIST_HEADERS_B QH
1254: WHERE
1255: ldets.line_detail_index = i.line_detail_index
1256: and ldets.list_header_id=qh.list_header_id
1257: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 2279: , QP_LIST_HEADERS_B QH

2275: proration_type_code, include_on_returns_flag,lines.line_index line_index
2276: from
2277: QP_LDETS_v ldets
2278: , QP_PREQ_LINES_TMP lines
2279: , QP_LIST_HEADERS_B QH
2280: where
2281: ldets.LIST_HEADER_ID = qh.list_header_id
2282: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED) --Bug8467307
2283: 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 2889: , QP_LIST_HEADERS_B QH

2885: , 1
2886: FROM
2887: QP_LDETS_v ldets
2888: , QP_PREQ_LINES_TMP lines
2889: , QP_LIST_HEADERS_B QH
2890: WHERE
2891: ldets.list_header_id=qh.list_header_id
2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2893: 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)