[Home] [Help] [Dependency Information]

VIEW: APPS.OZF_RESALE_LINES_V

Object Details

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT RESALE_LINE_ID
,      STATUS_CODE
,      USER_STATUS
,      RESALE_TRANSFER_TYPE
,      TRANSFER_TYPE_MEANING
,      DATE_INVOICED
,      INVOICE_NUMBER
,      DISTRIBUTOR_NUM
,      ORIG_SYSTEM_ITEM_NUMBER
,      ORIG_SYSTEM_UOM
,      ORIG_SYSTEM_QUANTITY
,      END_CUST_PARTY_ID
,      DERIVED_END_CUST_PARTY_NAME
,      INVENTORY_ITEM_ID
,      DERIVED_INVENTORY_ITEM_NAME
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      UOM_CODE
,      DERIVED_UOM
,      DISTRIBUTORAGREEMENT
,      AGREEMENT
,      DERIVED_AGREEMENT_NAME
,      CORRECTED_AGREEMENT_ID
,      CORRECTED_AGREEMENT_NAME
,      PURCHASE_PRICE
,      SELLING_PRICE
,      CLAIMED_AMOUNT
,      TOTAL_CLAIMED_AMOUNT
,      ORIG_SYSTEM_PURCHASE_PRICE
,      CALCULATED_PRICE
,      ALLOWED_AMOUNT
,      TOTAL_ALLOWED_AMOUNT
,      TOTAL_ACCEPTED_AMOUNT
,      DISPUTEDAMOUNT
,      ORIG_SYS_UOM
,      PRODUCT_TRANSFER_DATE
,      SHIP_FROM_CUST_ACCOUNT_ID
,      DERIVED_SHIP_FROM_PARTY_NAME
,      SHIP_FROM_CUST_NAME
,      SHIP_FROM_SITE_ID
,      SHIP_FROM_SITE_ADDRESS
,      SHIP_FROM_CONTACT_PARTY_ID
,      SHIP_FROM_CONTACT_NAME
,      SOLD_FROM_CUST_ACCOUNT_ID
,      DERIVED_SOLD_FROM_PARTY_NAME
,      SOLD_FROM_CUST_NAME
,      SOLD_FROM_SITE_ID
,      SOLD_FROM_SITE_ADDRESS
,      SOLD_FROM_CONTACT_PARTY_ID
,      SOLD_FROM_CONTACT_PARTY_NAME
,      BILL_TO_CUST_ACCOUNT_ID
,      DERIVED_BILL_TO_PARTY_NAME
,      BILL_TO_CUST_NAME
,      BILL_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ADDRESS
,      BILL_TO_SITE_USE_TYPE
,      BILL_TO_CONTACT_PARTY_ID
,      BILL_TO_CONTACT_NAME
,      SHIP_TO_CUST_ACCOUNT_ID
,      DERIVED_SHIP_TO_PARTY_NAME
,      SHIP_TO_CUST_NAME
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ADDRESS
,      SHIP_TO_SITE_USE_TYPE
,      SHIP_TO_CONTACT_PARTY_ID
,      SHIP_TO_PARTY_NAME
,      END_CUST_SITE_USE_ID
,      END_CUST_SITE_USE_ADDRESS
,      END_CUST_PARTY_SITE_ID
,      END_CUST_PARTY_SITE_ADDRESS
,      END_CUST_PARTY_NAME
,      DIRECT_CUSTOMER_FLAG
,      AGREEMENT_TYPE
,      AGREEMENT_PRICE
,      AGREEMENT_UOM_CODE
,      PRICE_LIST_ID
,      PRICE_LIST_NAME
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_LINE_REFERENCE
,      ORIG_SYSTEM_CURRENCY_CODE
,      ORIG_SYSTEM_SELLING_PRICE
,      ORIG_SYSTEM_PURCHASE_UOM
,      ORIG_SYSTEM_AGREEMENT_UOM
,      ORIG_SYSTEM_AGREEMENT_NAME
,      ORIG_SYSTEM_AGREEMENT_TYPE
,      ORIG_SYSTEM_AGREEMENT_STATUS
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      PO_NUMBER
,      PO_RELEASE_NUMBER
,      PO_TYPE
,      ORDER_NUMBER
,      DATE_ORDERED
,      ACCEPTED_AMOUNT
,      LINE_TOLERANCE_AMOUNT
,      TOLERANCE_FLAG
,      PURCHASE_UOM_CODE
,      ACCTD_SELLING_PRICE
,      QUANTITY
,      ACCTD_CALCULATED_PRICE
,      CALCULATED_AMOUNT
,      CREDIT_CODE
,      CREDIT_ADVICE_DATE
,      UPC_CODE
,      PRODUCT_CATEGORY_ID
,      CATEGORY_NAME
,      ORIG_SYSTEM_PURCHASE_CURR
,      ORIG_SYSTEM_AGREEMENT_CURR
,      ORIG_SYSTEM_AGREEMENT_PRICE
,      DATE_SHIPPED
,      ACCTD_PURCHASE_PRICE
,      TRACING_FLAG
,      END_CUST_SITE_USE_CODE
FROM APPS.OZF_RESALE_LINES_V;

Dependencies

[top of page]

APPS

FND_PROFILE - show dependent code

HZ_CUST_ACCOUNTS

HZ_PARTIES

MTL_SYSTEM_ITEMS_VL

MTL_UNITS_OF_MEASURE

OZF_LOOKUPS

OZF_RESALE_ADJUSTMENTS_ALL

OZF_RESALE_LINES_ALL

QP_LIST_HEADERS

APPS.OZF_RESALE_LINES_V is not referenced by any database object