VIEW: APPS.OE_BLKTPRT_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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