VIEW: APPS.QPR_SR_MODEL_HIER_V

Source

View Text - Preformatted

SELECT l.line_id, h.order_number || '-' || l.ordered_item, NULL, NULL, NULL, NULL, NULL, l.header_id || '-' || l1.inventory_item_id, h.order_number || '-' || l1.ordered_item, NULL, NULL, NULL, NULL, NULL, l1.inventory_item_id, l1.ordered_item, NULL, NULL, NULL, NULL, NULL, qpr_sr_util.get_all_ord_pk, qpr_sr_util.get_all_ord_desc, NULL, NULL, NULL, NULL, NULL, nvl(TRUNC(h.booked_date, 'dd'), to_date('1000/01/01', 'yyyy/mm/dd')) FROM oe_order_lines_all l, oe_order_headers_all h, oe_order_lines_all l1 WHERE h.header_id = l.header_id and l.booked_flag = 'Y' and h.booked_flag = 'Y' and l1.line_id= l.top_model_line_id AND l1.item_type_code in ('MODEL', 'KIT') and h.order_category_code <> 'RETURN' and l.line_category_code <> 'RETURN' and nvl(h.source_document_type_id,0) <> 10 and l.retrobill_request_id is null and nvl(l.order_source_id,0) <> 27 AND ((nvl(fnd_profile.value('QPR_INTERNAL_CUST'), 'N') = 'N' and h.sold_to_org_id not in ( select cust_account_id from hz_cust_accounts where nvl(customer_type, 'C') = 'I')) or nvl(fnd_profile.value('QPR_INTERNAL_CUST'), 'N') = 'Y')

View Text - HTML Formatted

SELECT L.LINE_ID
, H.ORDER_NUMBER || '-' || L.ORDERED_ITEM
, NULL
, NULL
, NULL
, NULL
, NULL
, L.HEADER_ID || '-' || L1.INVENTORY_ITEM_ID
, H.ORDER_NUMBER || '-' || L1.ORDERED_ITEM
, NULL
, NULL
, NULL
, NULL
, NULL
, L1.INVENTORY_ITEM_ID
, L1.ORDERED_ITEM
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_ALL_ORD_PK
, QPR_SR_UTIL.GET_ALL_ORD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(TRUNC(H.BOOKED_DATE
, 'DD')
, TO_DATE('1000/01/01'
, 'YYYY/MM/DD'))
FROM OE_ORDER_LINES_ALL L
, OE_ORDER_HEADERS_ALL H
, OE_ORDER_LINES_ALL L1
WHERE H.HEADER_ID = L.HEADER_ID
AND L.BOOKED_FLAG = 'Y'
AND H.BOOKED_FLAG = 'Y'
AND L1.LINE_ID= L.TOP_MODEL_LINE_ID
AND L1.ITEM_TYPE_CODE IN ('MODEL'
, 'KIT')
AND H.ORDER_CATEGORY_CODE <> 'RETURN'
AND L.LINE_CATEGORY_CODE <> 'RETURN'
AND NVL(H.SOURCE_DOCUMENT_TYPE_ID
, 0) <> 10
AND L.RETROBILL_REQUEST_ID IS NULL
AND NVL(L.ORDER_SOURCE_ID
, 0) <> 27
AND ((NVL(FND_PROFILE.VALUE('QPR_INTERNAL_CUST')
, 'N') = 'N'
AND H.SOLD_TO_ORG_ID NOT IN ( SELECT CUST_ACCOUNT_ID
FROM HZ_CUST_ACCOUNTS
WHERE NVL(CUSTOMER_TYPE
, 'C') = 'I')) OR NVL(FND_PROFILE.VALUE('QPR_INTERNAL_CUST')
, 'N') = 'Y')