VIEW: APPS.XNB_ORDER_LINES_V

Source

View Text - Preformatted

SELECT LINES.ATTRIBUTE1 ATTRIBUTE1, LINES.ATTRIBUTE2 ATTRIBUTE2, LINES.ATTRIBUTE3 ATTRIBUTE3, LINES.ATTRIBUTE4 ATTRIBUTE4, LINES.ATTRIBUTE5 ATTRIBUTE5, LINES.ATTRIBUTE6 ATTRIBUTE6, LINES.ATTRIBUTE7 ATTRIBUTE7, LINES.ATTRIBUTE8 ATTRIBUTE8, LINES.ATTRIBUTE9 ATTRIBUTE9, LINES.ATTRIBUTE10 ATTRIBUTE10, LINES.ATTRIBUTE11 ATTRIBUTE11, LINES.ATTRIBUTE12 ATTRIBUTE12, LINES.ATTRIBUTE13 ATTRIBUTE13, LINES.ATTRIBUTE14 ATTRIBUTE14, LINES.ATTRIBUTE15 ATTRIBUTE15, LINES.LINE_ID LINE_ID, LINES.TAX_CODE TAX_CODE, LINES.TAX_RATE TAX_RATE, LINES.TAX_DATE TAX_DATE, LINES.TAX_VALUE TAX_VALUE, LINES.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, LINES.LINK_TO_LINE_ID LINK_TO_LINE_ID, LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LINES.ORG_ID ORG_ID, LINES.PRICING_DATE PRICING_DATE, LINES.UNIT_SELLING_PRICE UNIT_SELLING_PRICE, LINES.UNIT_LIST_PRICE UNIT_LIST_PRICE, LINES.ORDERED_QUANTITY ORDERED_QUANTITY, LINES.ORDER_QUANTITY_UOM ORDERED_QUANTITY_UOM, LINES.PRICING_QUANTITY PRICING_QUANTITY, LINES.PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM, LINES.SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, LINES.SHIP_TO_ORG_ID SHIP_TO_ORG_ID, LINES.INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, LINES.LINE_TYPE_ID LINE_TYPE_ID, LINES.SOLD_TO_ORG_ID SOLD_TO_ORG_ID, LINES.HEADER_ID HEADER_ID, LINES.PRICE_LIST_ID PRICE_LIST_ID, LINES.CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE, LINES.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, LINES.PAYMENT_TERM_ID PAYMENT_TERM_ID, PAYMENT_TERMS.NAME PAYMENT_TERM_NAME, PAYMENT_TERMS.DESCRIPTION PAYMENT_DESCRIPTION, UOM_CONVS.UNIT_OF_MEASURE CHARGE_PERIODICITY_DESCRIPTION, ITEMS.SEGMENT1 ITEM_NAME, ITEMS.DESCRIPTION ITEM_DESCRIPTION, TRANSACTIONS.NAME ACTION, PRICE_LISTS.DESCRIPTION PRICE_LIST_DESCRIPTION, PRICE_LISTS.CURRENCY_CODE CURRENCY_CODE, BILL_TO_DETAILS.PRIMARY_BILL_TO_FLAG PRIMARY_BILL_TO_FLAG, BILL_TO_DETAILS.BILL_TO_OWNER_FLAG BILL_TO_OWNER_FLAG, BILL_TO_DETAILS.BILL_TO_ADDRESS BILL_TO_ADDRESS, BILL_TO_DETAILS.COUNTRY BILL_TO_COUNTRY, BILL_TO_DETAILS.STATE BILL_TO_STATE, BILL_TO_DETAILS.COUNTY BILL_TO_COUNTY, BILL_TO_DETAILS.CITY BILL_TO_CITY, BILL_TO_DETAILS.POSTAL_CODE BILL_TO_POSTAL_CODE, BILL_TO_DETAILS.ACCOUNT_NUMBER BILL_TO_ACCOUNT_NUMBER, BILL_TO_DETAILS.ACCOUNT_NAME BILL_TO_ACCOUNT_NAME, BILL_TO_DETAILS.PARTY_NUMBER BILL_TO_PARTY_NUMBER, BILL_TO_DETAILS.PARTY_NAME BILL_TO_PARTY_NAME, BILL_TO_DETAILS.PARTY_ATTRIBUTE1 PARTY_ATTRIBUTE1, BILL_TO_DETAILS.PARTY_ATTRIBUTE2 PARTY_ATTRIBUTE2, BILL_TO_DETAILS.PARTY_ATTRIBUTE3 PARTY_ATTRIBUTE3, BILL_TO_DETAILS.PARTY_ATTRIBUTE4 PARTY_ATTRIBUTE4, BILL_TO_DETAILS.PARTY_ATTRIBUTE5 PARTY_ATTRIBUTE5, BILL_TO_DETAILS.PARTY_ATTRIBUTE6 PARTY_ATTRIBUTE6, BILL_TO_DETAILS.PARTY_ATTRIBUTE7 PARTY_ATTRIBUTE7, BILL_TO_DETAILS.PARTY_ATTRIBUTE8 PARTY_ATTRIBUTE8, BILL_TO_DETAILS.PARTY_ATTRIBUTE9 PARTY_ATTRIBUTE9, BILL_TO_DETAILS.PARTY_ATTRIBUTE10 PARTY_ATTRIBUTE10, BILL_TO_DETAILS.PARTY_ATTRIBUTE11 PARTY_ATTRIBUTE11, BILL_TO_DETAILS.PARTY_ATTRIBUTE12 PARTY_ATTRIBUTE12, BILL_TO_DETAILS.PARTY_ATTRIBUTE13 PARTY_ATTRIBUTE13, BILL_TO_DETAILS.PARTY_ATTRIBUTE14 PARTY_ATTRIBUTE14, BILL_TO_DETAILS.PARTY_ATTRIBUTE15 PARTY_ATTRIBUTE15, BILL_TO_DETAILS.ACCT_ATTRIBUTE1 ACCT_ATTRIBUTE1, BILL_TO_DETAILS.ACCT_ATTRIBUTE2 ACCT_ATTRIBUTE2, BILL_TO_DETAILS.ACCT_ATTRIBUTE3 ACCT_ATTRIBUTE3, BILL_TO_DETAILS.ACCT_ATTRIBUTE4 ACCT_ATTRIBUTE4, BILL_TO_DETAILS.ACCT_ATTRIBUTE5 ACCT_ATTRIBUTE5, BILL_TO_DETAILS.ACCT_ATTRIBUTE6 ACCT_ATTRIBUTE6, BILL_TO_DETAILS.ACCT_ATTRIBUTE7 ACCT_ATTRIBUTE7, BILL_TO_DETAILS.ACCT_ATTRIBUTE8 ACCT_ATTRIBUTE8, BILL_TO_DETAILS.ACCT_ATTRIBUTE9 ACCT_ATTRIBUTE9, BILL_TO_DETAILS.ACCT_ATTRIBUTE10 ACCT_ATTRIBUTE10, BILL_TO_DETAILS.ACCT_ATTRIBUTE11 ACCT_ATTRIBUTE11, BILL_TO_DETAILS.ACCT_ATTRIBUTE12 ACCT_ATTRIBUTE12, BILL_TO_DETAILS.ACCT_ATTRIBUTE13 ACCT_ATTRIBUTE13, BILL_TO_DETAILS.ACCT_ATTRIBUTE14 ACCT_ATTRIBUTE14, BILL_TO_DETAILS.ACCT_ATTRIBUTE15 ACCT_ATTRIBUTE15, INSTALL_BASE.INSTANCE_ID INSTANCE_ID, INSTALL_BASE.INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION, INSTALL_BASE.INSTALL_DATE INSTALL_DATE, INSTALL_BASE.ACTIVE_START_DATE ACTIVE_START_DATE, INSTALL_BASE.ACTIVE_END_DATE ACTIVE_END_DATE, INSTALL_BASE.QUANTITY INSTALL_BASE_QUANTITY, INSTALL_BASE.UNIT_OF_MEASURE INSTALL_BASE_UOM, INSTALL_BASE.INSTALL_LOCATION_ID INSTALL_LOCATION_ID, INSTALL_BASE.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID FROM OE_ORDER_LINES_ALL LINES, RA_TERMS_VL PAYMENT_TERMS, MTL_UOM_CONVERSIONS UOM_CONVS, MTL_SYSTEM_ITEMS_VL ITEMS, OE_TRANSACTION_TYPES_VL TRANSACTIONS, QP_LIST_HEADERS_VL PRICE_LISTS, XNB_BILL_TO_PARTY_DETAILS BILL_TO_DETAILS, CSI_ITEM_INSTANCES INSTALL_BASE WHERE LINES.PAYMENT_TERM_ID = PAYMENT_TERMS.TERM_ID(+) AND LINES.CHARGE_PERIODICITY_CODE = UOM_CONVS.UOM_CODE(+) AND LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND LINES.SHIP_FROM_ORG_ID = ITEMS.ORGANIZATION_ID AND ITEMS.INVOICEABLE_ITEM_FLAG = 'N' AND LINES.LINE_TYPE_ID = TRANSACTIONS.TRANSACTION_TYPE_ID(+) AND LINES.PRICE_LIST_ID = PRICE_LISTS.LIST_HEADER_ID(+) AND LINES.LINE_ID = BILL_TO_DETAILS.ORDER_LINE_ID(+) AND LINES.LINE_ID = INSTALL_BASE.LAST_OE_ORDER_LINE_ID(+)

View Text - HTML Formatted

SELECT LINES.ATTRIBUTE1 ATTRIBUTE1
, LINES.ATTRIBUTE2 ATTRIBUTE2
, LINES.ATTRIBUTE3 ATTRIBUTE3
, LINES.ATTRIBUTE4 ATTRIBUTE4
, LINES.ATTRIBUTE5 ATTRIBUTE5
, LINES.ATTRIBUTE6 ATTRIBUTE6
, LINES.ATTRIBUTE7 ATTRIBUTE7
, LINES.ATTRIBUTE8 ATTRIBUTE8
, LINES.ATTRIBUTE9 ATTRIBUTE9
, LINES.ATTRIBUTE10 ATTRIBUTE10
, LINES.ATTRIBUTE11 ATTRIBUTE11
, LINES.ATTRIBUTE12 ATTRIBUTE12
, LINES.ATTRIBUTE13 ATTRIBUTE13
, LINES.ATTRIBUTE14 ATTRIBUTE14
, LINES.ATTRIBUTE15 ATTRIBUTE15
, LINES.LINE_ID LINE_ID
, LINES.TAX_CODE TAX_CODE
, LINES.TAX_RATE TAX_RATE
, LINES.TAX_DATE TAX_DATE
, LINES.TAX_VALUE TAX_VALUE
, LINES.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, LINES.LINK_TO_LINE_ID LINK_TO_LINE_ID
, LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LINES.ORG_ID ORG_ID
, LINES.PRICING_DATE PRICING_DATE
, LINES.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, LINES.UNIT_LIST_PRICE UNIT_LIST_PRICE
, LINES.ORDERED_QUANTITY ORDERED_QUANTITY
, LINES.ORDER_QUANTITY_UOM ORDERED_QUANTITY_UOM
, LINES.PRICING_QUANTITY PRICING_QUANTITY
, LINES.PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM
, LINES.SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, LINES.SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, LINES.INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, LINES.LINE_TYPE_ID LINE_TYPE_ID
, LINES.SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, LINES.HEADER_ID HEADER_ID
, LINES.PRICE_LIST_ID PRICE_LIST_ID
, LINES.CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE
, LINES.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, LINES.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PAYMENT_TERMS.NAME PAYMENT_TERM_NAME
, PAYMENT_TERMS.DESCRIPTION PAYMENT_DESCRIPTION
, UOM_CONVS.UNIT_OF_MEASURE CHARGE_PERIODICITY_DESCRIPTION
, ITEMS.SEGMENT1 ITEM_NAME
, ITEMS.DESCRIPTION ITEM_DESCRIPTION
, TRANSACTIONS.NAME ACTION
, PRICE_LISTS.DESCRIPTION PRICE_LIST_DESCRIPTION
, PRICE_LISTS.CURRENCY_CODE CURRENCY_CODE
, BILL_TO_DETAILS.PRIMARY_BILL_TO_FLAG PRIMARY_BILL_TO_FLAG
, BILL_TO_DETAILS.BILL_TO_OWNER_FLAG BILL_TO_OWNER_FLAG
, BILL_TO_DETAILS.BILL_TO_ADDRESS BILL_TO_ADDRESS
, BILL_TO_DETAILS.COUNTRY BILL_TO_COUNTRY
, BILL_TO_DETAILS.STATE BILL_TO_STATE
, BILL_TO_DETAILS.COUNTY BILL_TO_COUNTY
, BILL_TO_DETAILS.CITY BILL_TO_CITY
, BILL_TO_DETAILS.POSTAL_CODE BILL_TO_POSTAL_CODE
, BILL_TO_DETAILS.ACCOUNT_NUMBER BILL_TO_ACCOUNT_NUMBER
, BILL_TO_DETAILS.ACCOUNT_NAME BILL_TO_ACCOUNT_NAME
, BILL_TO_DETAILS.PARTY_NUMBER BILL_TO_PARTY_NUMBER
, BILL_TO_DETAILS.PARTY_NAME BILL_TO_PARTY_NAME
, BILL_TO_DETAILS.PARTY_ATTRIBUTE1 PARTY_ATTRIBUTE1
, BILL_TO_DETAILS.PARTY_ATTRIBUTE2 PARTY_ATTRIBUTE2
, BILL_TO_DETAILS.PARTY_ATTRIBUTE3 PARTY_ATTRIBUTE3
, BILL_TO_DETAILS.PARTY_ATTRIBUTE4 PARTY_ATTRIBUTE4
, BILL_TO_DETAILS.PARTY_ATTRIBUTE5 PARTY_ATTRIBUTE5
, BILL_TO_DETAILS.PARTY_ATTRIBUTE6 PARTY_ATTRIBUTE6
, BILL_TO_DETAILS.PARTY_ATTRIBUTE7 PARTY_ATTRIBUTE7
, BILL_TO_DETAILS.PARTY_ATTRIBUTE8 PARTY_ATTRIBUTE8
, BILL_TO_DETAILS.PARTY_ATTRIBUTE9 PARTY_ATTRIBUTE9
, BILL_TO_DETAILS.PARTY_ATTRIBUTE10 PARTY_ATTRIBUTE10
, BILL_TO_DETAILS.PARTY_ATTRIBUTE11 PARTY_ATTRIBUTE11
, BILL_TO_DETAILS.PARTY_ATTRIBUTE12 PARTY_ATTRIBUTE12
, BILL_TO_DETAILS.PARTY_ATTRIBUTE13 PARTY_ATTRIBUTE13
, BILL_TO_DETAILS.PARTY_ATTRIBUTE14 PARTY_ATTRIBUTE14
, BILL_TO_DETAILS.PARTY_ATTRIBUTE15 PARTY_ATTRIBUTE15
, BILL_TO_DETAILS.ACCT_ATTRIBUTE1 ACCT_ATTRIBUTE1
, BILL_TO_DETAILS.ACCT_ATTRIBUTE2 ACCT_ATTRIBUTE2
, BILL_TO_DETAILS.ACCT_ATTRIBUTE3 ACCT_ATTRIBUTE3
, BILL_TO_DETAILS.ACCT_ATTRIBUTE4 ACCT_ATTRIBUTE4
, BILL_TO_DETAILS.ACCT_ATTRIBUTE5 ACCT_ATTRIBUTE5
, BILL_TO_DETAILS.ACCT_ATTRIBUTE6 ACCT_ATTRIBUTE6
, BILL_TO_DETAILS.ACCT_ATTRIBUTE7 ACCT_ATTRIBUTE7
, BILL_TO_DETAILS.ACCT_ATTRIBUTE8 ACCT_ATTRIBUTE8
, BILL_TO_DETAILS.ACCT_ATTRIBUTE9 ACCT_ATTRIBUTE9
, BILL_TO_DETAILS.ACCT_ATTRIBUTE10 ACCT_ATTRIBUTE10
, BILL_TO_DETAILS.ACCT_ATTRIBUTE11 ACCT_ATTRIBUTE11
, BILL_TO_DETAILS.ACCT_ATTRIBUTE12 ACCT_ATTRIBUTE12
, BILL_TO_DETAILS.ACCT_ATTRIBUTE13 ACCT_ATTRIBUTE13
, BILL_TO_DETAILS.ACCT_ATTRIBUTE14 ACCT_ATTRIBUTE14
, BILL_TO_DETAILS.ACCT_ATTRIBUTE15 ACCT_ATTRIBUTE15
, INSTALL_BASE.INSTANCE_ID INSTANCE_ID
, INSTALL_BASE.INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION
, INSTALL_BASE.INSTALL_DATE INSTALL_DATE
, INSTALL_BASE.ACTIVE_START_DATE ACTIVE_START_DATE
, INSTALL_BASE.ACTIVE_END_DATE ACTIVE_END_DATE
, INSTALL_BASE.QUANTITY INSTALL_BASE_QUANTITY
, INSTALL_BASE.UNIT_OF_MEASURE INSTALL_BASE_UOM
, INSTALL_BASE.INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, INSTALL_BASE.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID
FROM OE_ORDER_LINES_ALL LINES
, RA_TERMS_VL PAYMENT_TERMS
, MTL_UOM_CONVERSIONS UOM_CONVS
, MTL_SYSTEM_ITEMS_VL ITEMS
, OE_TRANSACTION_TYPES_VL TRANSACTIONS
, QP_LIST_HEADERS_VL PRICE_LISTS
, XNB_BILL_TO_PARTY_DETAILS BILL_TO_DETAILS
, CSI_ITEM_INSTANCES INSTALL_BASE
WHERE LINES.PAYMENT_TERM_ID = PAYMENT_TERMS.TERM_ID(+)
AND LINES.CHARGE_PERIODICITY_CODE = UOM_CONVS.UOM_CODE(+)
AND LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND LINES.SHIP_FROM_ORG_ID = ITEMS.ORGANIZATION_ID
AND ITEMS.INVOICEABLE_ITEM_FLAG = 'N'
AND LINES.LINE_TYPE_ID = TRANSACTIONS.TRANSACTION_TYPE_ID(+)
AND LINES.PRICE_LIST_ID = PRICE_LISTS.LIST_HEADER_ID(+)
AND LINES.LINE_ID = BILL_TO_DETAILS.ORDER_LINE_ID(+)
AND LINES.LINE_ID = INSTALL_BASE.LAST_OE_ORDER_LINE_ID(+)