VIEW: APPS.OZF_RESALE_WEBADI_DOWNLOAD_V

Source

View Text - Preformatted

SELECT HDR.RESALE_BATCH_ID, HDR.OBJECT_VERSION_NUMBER, HDR.LAST_UPDATE_DATE, HDR.LAST_UPDATED_BY, HDR.LAST_UPDATE_LOGIN, BATCH_TYPE, BATCH_NUMBER, BATCH_COUNT, YEAR, MONTH, REPORT_DATE, REPORT_START_DATE, REPORT_END_DATE, REFERENCE_TYPE, REFERENCE_NUMBER, COMMENTS, PARTNER_CLAIM_NUMBER, TRANSACTION_PURPOSE_CODE, TRANSACTION_TYPE_CODE, PARTNER_TYPE, PARTNER_PARTY_ID, PARTNER_CUST_ACCOUNT_ID, PARTNER_SITE_ID, PARTNER_CONTACT_PARTY_ID, PARTNER_CONTACT_NAME, PARTNER_EMAIL, PARTNER_PHONE, PARTNER_FAX, HDR.CURRENCY_CODE, HDR.CLAIMED_AMOUNT, HDR.CREDIT_CODE, HDR.CREDIT_ADVICE_DATE, ATTRIBUTE_CATEGORY , ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, RESALE_LINE_INT_ID, RESALE_TRANSFER_TYPE, PRODUCT_TRANSFER_MOVEMENT_TYPE, PRODUCT_TRANSFER_DATE, TRACING_FLAG, SHIP_FROM_CUST_ACCOUNT_ID, SHIP_FROM_SITE_ID, SHIP_FROM_PARTY_NAME, SHIP_FROM_LOCATION, SHIP_FROM_ADDRESS, SHIP_FROM_CITY, SHIP_FROM_STATE, SHIP_FROM_POSTAL_CODE, SHIP_FROM_COUNTRY, SHIP_FROM_CONTACT_PARTY_ID, SHIP_FROM_CONTACT_NAME, SHIP_FROM_EMAIL, SHIP_FROM_PHONE, SHIP_FROM_FAX, SOLD_FROM_CUST_ACCOUNT_ID, SOLD_FROM_SITE_ID, SOLD_FROM_PARTY_NAME, SOLD_FROM_LOCATION, SOLD_FROM_ADDRESS, SOLD_FROM_CITY, SOLD_FROM_STATE, SOLD_FROM_POSTAL_CODE, SOLD_FROM_COUNTRY, SOLD_FROM_CONTACT_PARTY_ID, SOLD_FROM_CONTACT_NAME, SOLD_FROM_EMAIL, SOLD_FROM_PHONE, SOLD_FROM_FAX, BILL_TO_CUST_ACCOUNT_ID, BILL_TO_SITE_USE_ID, BILL_TO_PARTY_NAME, BILL_TO_DUNS_NUMBER, BILL_TO_LOCATION, BILL_TO_ADDRESS, BILL_TO_CITY, BILL_TO_STATE, BILL_TO_POSTAL_CODE, BILL_TO_COUNTRY, BILL_TO_CONTACT_PARTY_ID, BILL_TO_CONTACT_NAME, BILL_TO_EMAIL, BILL_TO_PHONE, BILL_TO_FAX, SHIP_TO_CUST_ACCOUNT_ID, SHIP_TO_SITE_USE_ID, SHIP_TO_PARTY_NAME, SHIP_TO_DUNS_NUMBER, SHIP_TO_LOCATION, SHIP_TO_ADDRESS, SHIP_TO_CITY, SHIP_TO_COUNTRY, SHIP_TO_POSTAL_CODE, SHIP_TO_STATE, SHIP_TO_CONTACT_PARTY_ID, SHIP_TO_CONTACT_NAME, SHIP_TO_EMAIL, SHIP_TO_PHONE, SHIP_TO_FAX, END_CUST_PARTY_ID, END_CUST_SITE_USE_ID, END_CUST_SITE_USE_CODE, END_CUST_PARTY_SITE_ID, END_CUST_PARTY_NAME, END_CUST_LOCATION, END_CUST_ADDRESS, END_CUST_CITY, END_CUST_STATE, END_CUST_POSTAL_CODE, END_CUST_COUNTRY, END_CUST_CONTACT_PARTY_ID, END_CUST_CONTACT_NAME, END_CUST_EMAIL, END_CUST_PHONE, END_CUST_FAX, DIRECT_CUSTOMER_FLAG, ORDER_TYPE_ID, ORDER_TYPE, ORDER_CATEGORY, AGREEMENT_TYPE, AGREEMENT_ID, AGREEMENT_NAME, AGREEMENT_PRICE, AGREEMENT_UOM_CODE, CORRECTED_AGREEMENT_ID, CORRECTED_AGREEMENT_NAME, PRICE_LIST_ID, PRICE_LIST_NAME, ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_LINE_REFERENCE, ORIG_SYSTEM_CURRENCY_CODE, ORIG_SYSTEM_SELLING_PRICE, ORIG_SYSTEM_QUANTITY, ORIG_SYSTEM_UOM, ORIG_SYSTEM_PURCHASE_UOM, ORIG_SYSTEM_PURCHASE_CURR, ORIG_SYSTEM_PURCHASE_PRICE, ORIG_SYSTEM_PURCHASE_QUANTITY, ORIG_SYSTEM_AGREEMENT_UOM, ORIG_SYSTEM_AGREEMENT_NAME, ORIG_SYSTEM_AGREEMENT_TYPE, ORIG_SYSTEM_AGREEMENT_STATUS, ORIG_SYSTEM_AGREEMENT_CURR, ORIG_SYSTEM_AGREEMENT_PRICE, ORIG_SYSTEM_AGREEMENT_QUANTITY, ORIG_SYSTEM_ITEM_NUMBER, linE.CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE, PO_NUMBER, PO_RELEASE_NUMBER, PO_TYPE, INVOICE_NUMBER, DATE_INVOICED, ORDER_NUMBER, DATE_ORDERED, DATE_SHIPPED, linE.CLAIMED_AMOUNT, TOTAL_CLAIMED_AMOUNT, PURCHASE_PRICE, PURCHASE_UOM_CODE, SELLING_PRICE, UOM_CODE, QUANTITY, linE.CREDIT_CODE, linE.CREDIT_ADVICE_DATE, UPC_CODE, INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION, INVENTORY_ITEM_SEGMENT1, INVENTORY_ITEM_SEGMENT2, INVENTORY_ITEM_SEGMENT3, INVENTORY_ITEM_SEGMENT4, INVENTORY_ITEM_SEGMENT5, INVENTORY_ITEM_SEGMENT6, INVENTORY_ITEM_SEGMENT7, INVENTORY_ITEM_SEGMENT8, INVENTORY_ITEM_SEGMENT9, INVENTORY_ITEM_SEGMENT10, INVENTORY_ITEM_SEGMENT11, INVENTORY_ITEM_SEGMENT12, INVENTORY_ITEM_SEGMENT13, INVENTORY_ITEM_SEGMENT14, INVENTORY_ITEM_SEGMENT15, INVENTORY_ITEM_SEGMENT16, INVENTORY_ITEM_SEGMENT17, INVENTORY_ITEM_SEGMENT18, INVENTORY_ITEM_SEGMENT19, INVENTORY_ITEM_SEGMENT20, PRODUCT_CATEGORY_ID, CATEGORY_NAME, DUPLICATED_LINE_ID, DUPLICATED_ADJUSTMENT_ID, RESPONSE_TYPE, RESPONSE_CODE, REJECT_REASON_CODE, FOLLOWUP_ACTION_CODE, NET_ADJUSTED_AMOUNT, HEADER_ATTRIBUTE_CATEGORY, HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14, HEADER_ATTRIBUTE15, LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1, LINE_ATTRIBUTE2, LINE_ATTRIBUTE3, LINE_ATTRIBUTE4, LINE_ATTRIBUTE5, LINE_ATTRIBUTE6, LINE_ATTRIBUTE7, LINE_ATTRIBUTE8, LINE_ATTRIBUTE9, LINE_ATTRIBUTE10, LINE_ATTRIBUTE11, LINE_ATTRIBUTE12, LINE_ATTRIBUTE13, LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 FROM OZF_RESALE_BATCHES_ALL HDR, OZF_RESALE_LINES_INT_ALL LINE WHERE HDR.RESALE_BATCH_ID = LINE.RESALE_BATCH_ID

View Text - HTML Formatted

SELECT HDR.RESALE_BATCH_ID
, HDR.OBJECT_VERSION_NUMBER
, HDR.LAST_UPDATE_DATE
, HDR.LAST_UPDATED_BY
, HDR.LAST_UPDATE_LOGIN
, BATCH_TYPE
, BATCH_NUMBER
, BATCH_COUNT
, YEAR
, MONTH
, REPORT_DATE
, REPORT_START_DATE
, REPORT_END_DATE
, REFERENCE_TYPE
, REFERENCE_NUMBER
, COMMENTS
, PARTNER_CLAIM_NUMBER
, TRANSACTION_PURPOSE_CODE
, TRANSACTION_TYPE_CODE
, PARTNER_TYPE
, PARTNER_PARTY_ID
, PARTNER_CUST_ACCOUNT_ID
, PARTNER_SITE_ID
, PARTNER_CONTACT_PARTY_ID
, PARTNER_CONTACT_NAME
, PARTNER_EMAIL
, PARTNER_PHONE
, PARTNER_FAX
, HDR.CURRENCY_CODE
, HDR.CLAIMED_AMOUNT
, HDR.CREDIT_CODE
, HDR.CREDIT_ADVICE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RESALE_LINE_INT_ID
, RESALE_TRANSFER_TYPE
, PRODUCT_TRANSFER_MOVEMENT_TYPE
, PRODUCT_TRANSFER_DATE
, TRACING_FLAG
, SHIP_FROM_CUST_ACCOUNT_ID
, SHIP_FROM_SITE_ID
, SHIP_FROM_PARTY_NAME
, SHIP_FROM_LOCATION
, SHIP_FROM_ADDRESS
, SHIP_FROM_CITY
, SHIP_FROM_STATE
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY
, SHIP_FROM_CONTACT_PARTY_ID
, SHIP_FROM_CONTACT_NAME
, SHIP_FROM_EMAIL
, SHIP_FROM_PHONE
, SHIP_FROM_FAX
, SOLD_FROM_CUST_ACCOUNT_ID
, SOLD_FROM_SITE_ID
, SOLD_FROM_PARTY_NAME
, SOLD_FROM_LOCATION
, SOLD_FROM_ADDRESS
, SOLD_FROM_CITY
, SOLD_FROM_STATE
, SOLD_FROM_POSTAL_CODE
, SOLD_FROM_COUNTRY
, SOLD_FROM_CONTACT_PARTY_ID
, SOLD_FROM_CONTACT_NAME
, SOLD_FROM_EMAIL
, SOLD_FROM_PHONE
, SOLD_FROM_FAX
, BILL_TO_CUST_ACCOUNT_ID
, BILL_TO_SITE_USE_ID
, BILL_TO_PARTY_NAME
, BILL_TO_DUNS_NUMBER
, BILL_TO_LOCATION
, BILL_TO_ADDRESS
, BILL_TO_CITY
, BILL_TO_STATE
, BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY
, BILL_TO_CONTACT_PARTY_ID
, BILL_TO_CONTACT_NAME
, BILL_TO_EMAIL
, BILL_TO_PHONE
, BILL_TO_FAX
, SHIP_TO_CUST_ACCOUNT_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_PARTY_NAME
, SHIP_TO_DUNS_NUMBER
, SHIP_TO_LOCATION
, SHIP_TO_ADDRESS
, SHIP_TO_CITY
, SHIP_TO_COUNTRY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_STATE
, SHIP_TO_CONTACT_PARTY_ID
, SHIP_TO_CONTACT_NAME
, SHIP_TO_EMAIL
, SHIP_TO_PHONE
, SHIP_TO_FAX
, END_CUST_PARTY_ID
, END_CUST_SITE_USE_ID
, END_CUST_SITE_USE_CODE
, END_CUST_PARTY_SITE_ID
, END_CUST_PARTY_NAME
, END_CUST_LOCATION
, END_CUST_ADDRESS
, END_CUST_CITY
, END_CUST_STATE
, END_CUST_POSTAL_CODE
, END_CUST_COUNTRY
, END_CUST_CONTACT_PARTY_ID
, END_CUST_CONTACT_NAME
, END_CUST_EMAIL
, END_CUST_PHONE
, END_CUST_FAX
, DIRECT_CUSTOMER_FLAG
, ORDER_TYPE_ID
, ORDER_TYPE
, ORDER_CATEGORY
, AGREEMENT_TYPE
, AGREEMENT_ID
, AGREEMENT_NAME
, AGREEMENT_PRICE
, AGREEMENT_UOM_CODE
, CORRECTED_AGREEMENT_ID
, CORRECTED_AGREEMENT_NAME
, PRICE_LIST_ID
, PRICE_LIST_NAME
, ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_LINE_REFERENCE
, ORIG_SYSTEM_CURRENCY_CODE
, ORIG_SYSTEM_SELLING_PRICE
, ORIG_SYSTEM_QUANTITY
, ORIG_SYSTEM_UOM
, ORIG_SYSTEM_PURCHASE_UOM
, ORIG_SYSTEM_PURCHASE_CURR
, ORIG_SYSTEM_PURCHASE_PRICE
, ORIG_SYSTEM_PURCHASE_QUANTITY
, ORIG_SYSTEM_AGREEMENT_UOM
, ORIG_SYSTEM_AGREEMENT_NAME
, ORIG_SYSTEM_AGREEMENT_TYPE
, ORIG_SYSTEM_AGREEMENT_STATUS
, ORIG_SYSTEM_AGREEMENT_CURR
, ORIG_SYSTEM_AGREEMENT_PRICE
, ORIG_SYSTEM_AGREEMENT_QUANTITY
, ORIG_SYSTEM_ITEM_NUMBER
, LINE.CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE
, PO_NUMBER
, PO_RELEASE_NUMBER
, PO_TYPE
, INVOICE_NUMBER
, DATE_INVOICED
, ORDER_NUMBER
, DATE_ORDERED
, DATE_SHIPPED
, LINE.CLAIMED_AMOUNT
, TOTAL_CLAIMED_AMOUNT
, PURCHASE_PRICE
, PURCHASE_UOM_CODE
, SELLING_PRICE
, UOM_CODE
, QUANTITY
, LINE.CREDIT_CODE
, LINE.CREDIT_ADVICE_DATE
, UPC_CODE
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, INVENTORY_ITEM_SEGMENT1
, INVENTORY_ITEM_SEGMENT2
, INVENTORY_ITEM_SEGMENT3
, INVENTORY_ITEM_SEGMENT4
, INVENTORY_ITEM_SEGMENT5
, INVENTORY_ITEM_SEGMENT6
, INVENTORY_ITEM_SEGMENT7
, INVENTORY_ITEM_SEGMENT8
, INVENTORY_ITEM_SEGMENT9
, INVENTORY_ITEM_SEGMENT10
, INVENTORY_ITEM_SEGMENT11
, INVENTORY_ITEM_SEGMENT12
, INVENTORY_ITEM_SEGMENT13
, INVENTORY_ITEM_SEGMENT14
, INVENTORY_ITEM_SEGMENT15
, INVENTORY_ITEM_SEGMENT16
, INVENTORY_ITEM_SEGMENT17
, INVENTORY_ITEM_SEGMENT18
, INVENTORY_ITEM_SEGMENT19
, INVENTORY_ITEM_SEGMENT20
, PRODUCT_CATEGORY_ID
, CATEGORY_NAME
, DUPLICATED_LINE_ID
, DUPLICATED_ADJUSTMENT_ID
, RESPONSE_TYPE
, RESPONSE_CODE
, REJECT_REASON_CODE
, FOLLOWUP_ACTION_CODE
, NET_ADJUSTED_AMOUNT
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
FROM OZF_RESALE_BATCHES_ALL HDR
, OZF_RESALE_LINES_INT_ALL LINE
WHERE HDR.RESALE_BATCH_ID = LINE.RESALE_BATCH_ID