View: OE_BLKTPRT_LINES_V

Product:	ONT - Order Management
Description:	This view is used to print the blanket lines information from the blanket sales agreement
Implementation/DBA Data:	APPS.OE_BLKTPRT_LINES_V

View Text

SELECT OBL.HEADER_ID HEADER_ID
, OBL.LINE_NUMBER LINE_NUMBER
, OBL.LINE_ID
, OBL.CUST_PO_NUMBER CUSTOMER_PO_NUMBER
, OBL.SHIP_TO_ORG_ID
, OBL.DELIVER_TO_ORG_ID
, OBL.INVOICE_TO_ORG_ID
, OBL.INVENTORY_ITEM_ID
, OBL.SOLD_TO_ORG_ID
, OBL.ORDERED_ITEM
, OBL.ORDERED_ITEM_ID
, OBL.ITEM_IDENTIFIER_TYPE
, ITMLKUP.MEANING ITEM_IDENTIFIER
, OE_CONTRACTS_UTIL.GET_ITEM_INFO('I'
, OBL.ITEM_IDENTIFIER_TYPE
, OBL.INVENTORY_ITEM_ID
, OBL.ORDERED_ITEM_ID
, OBL.SOLD_TO_ORG_ID
, OBL.ORDERED_ITEM
, OBH.ORG_ID) ITEM
, OE_CONTRACTS_UTIL.GET_ITEM_INFO('D'
, OBL.ITEM_IDENTIFIER_TYPE
, OBL.INVENTORY_ITEM_ID
, OBL.ORDERED_ITEM_ID
, OBL.SOLD_TO_ORG_ID
, OBL.ORDERED_ITEM
, OBH.ORG_ID) ITEM_DESCRIPTION
, OBL.ORDER_QUANTITY_UOM UOM
, OBLE.START_DATE_ACTIVE ACTIVATION_DATE
, OBLE.END_DATE_ACTIVE EXPIRATION_DATE
, FRLKUP.MEANING FREIGHT_TERMS
, SMLKUP.MEANING SHIPPING_METHOD
, TERM.NAME PAYMENT_TERM
, INVRULES.NAME INVOICING_RULE
, TO_CHAR(OBLE.BLANKET_LINE_MIN_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK(OBH.TRANSACTIONAL_CURR_CODE
, 20)) BLANKET_LINE_MIN_AMOUNT
, TO_CHAR(OBLE.BLANKET_LINE_MAX_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK(OBH.TRANSACTIONAL_CURR_CODE
, 20)) BLANKET_LINE_MAX_AMOUNT
, OBLE.BLANKET_MIN_QUANTITY
, OBLE.BLANKET_MAX_QUANTITY
, OBL.PRICE_LIST_ID
, OBLE.QP_LIST_LINE_ID
, OBLE.MODIFIER_LIST_LINE_ID
FROM OE_BLANKET_HEADERS_ALL OBH
, OE_BLANKET_LINES_ALL OBL
, OE_BLANKET_LINES_EXT OBLE
, OE_LOOKUPS FRLKUP
, FND_LOOKUP_VALUES SMLKUP
, RA_TERMS_TL TERM
, RA_RULES INVRULES
, OE_LOOKUPS ITMLKUP
WHERE OBH.HEADER_ID = OBL.HEADER_ID
AND OBL.LINE_ID = OBLE.LINE_ID
AND OBL.ITEM_IDENTIFIER_TYPE = ITMLKUP.LOOKUP_CODE(+)
AND ITMLKUP.LOOKUP_TYPE(+) = 'ITEM_IDENTIFIER_TYPE'
AND OBL.FREIGHT_TERMS_CODE = FRLKUP.LOOKUP_CODE(+)
AND FRLKUP.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
AND FRLKUP.ENABLED_FLAG(+) = 'Y'
AND OBL.SHIPPING_METHOD_CODE = SMLKUP.LOOKUP_CODE(+)
AND SMLKUP.LANGUAGE(+) = USERENV('LANG')
AND SMLKUP.VIEW_APPLICATION_ID(+) = 3
AND SMLKUP.LOOKUP_TYPE(+) = 'SHIP_METHOD'
AND OBL.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND TERM.LANGUAGE(+) = USERENV('LANG')
AND OBL.INVOICING_RULE_ID = INVRULES.RULE_ID(+)
AND INVRULES.TYPE(+) = 'I'
AND OBL.SALES_DOCUMENT_TYPE_CODE = 'B' ORDER BY LINE_NUMBER

Columns