View: OE_ORG_FREIGHT_V | Oracle EBS ETRM Search

Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object.

APPS.JTF_CUST_ACCOUNTS_ALL_V·↳ HZ_CUST_ACCOUNTS·Explore JTF module →

View: JTF_CUST_ACCOUNTS_ALL_V 12.1.1

JTF - CRM Foundation·134 columns

Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object.

APPS.JTF_CUST_ACCOUNTS_ALL_V·↳ HZ_CUST_ACCOUNTS·Explore JTF module →

Table: SO_HEADER_ATTRIBUTES 12.1.1 standalone

owner OE·OE - Order Entry·31 columns

Additional attributes of order headers

OE.SO_HEADER_ATTRIBUTES·Explore OE module →

Table: SO_HEADER_ATTRIBUTES 12.2.2 standalone

owner OE·OE - Order Entry·31 columns

Additional attributes of order headers

OE.SO_HEADER_ATTRIBUTES·Explore OE module →

View: JTF_HZ_PARTIES_V 12.2.2

JTF - CRM Foundation·94 columns

JTF_HZ_PARTIES_V retrieves information about parties such as organizations, people, and groups, including the identifying address information for the party.

APPS.JTF_HZ_PARTIES_V·↳ HZ_PARTIES·Explore JTF module →

View: AMS_ORGANIZATION_V 12.2.2

AMS - Marketing·95 columns

This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.

APPS.AMS_ORGANIZATION_V·↳ HZ_PARTIES·Explore AMS module →

View: AP_PAYMENT_SCHEDULES_V 12.1.1

AR - Receivables·74 columns

APPS.AP_PAYMENT_SCHEDULES_V·↳ AP_BATCHES_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_PKG·Explore AR module →

View: AMS_P_PERSON_V 12.2.2

AMS - Marketing·94 columns

This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.

APPS.AMS_P_PERSON_V·↳ HZ_PARTIES·Explore AMS module →

View: AMS_P_PERSON_V 12.1.1

AMS - Marketing·94 columns

This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.

APPS.AMS_P_PERSON_V·↳ HZ_PARTIES·Explore AMS module →

View: ASO_I_OE_ORDER_HEADERS_V 12.1.1

ASO - Order Capture·139 columns

This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.

APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →

View: AP_PAYMENT_SCHEDULES_V 12.2.2

AP - Payables·74 columns

APPS.AP_PAYMENT_SCHEDULES_V·↳ AP_BATCHES_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_PKG·Explore AP module →

View: JTF_CUST_ACCT_SITES_V 12.2.2

JTF - CRM Foundation·72 columns

JTF_CUST_ACCT_SITES retrieves information about customer sites. One customer account can have multiple sites.

APPS.JTF_CUST_ACCT_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·Explore JTF module →

View: FA_ADDITIONS_NON_SEC_VL 12.2.2

OFA - Assets·82 columns

APPS.FA_ADDITIONS_NON_SEC_VL·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·Explore OFA module →

View: JTF_CUST_ACCOUNTS_ROLES_V 12.2.2

JTF - CRM Foundation·69 columns

JTF_CUST_ACCOUNT_ROLES retrieves information about the roles that parties perform in customer accounts.

APPS.JTF_CUST_ACCOUNTS_ROLES_V·↳ HZ_CUST_ACCOUNT_ROLES·Explore JTF module →

View: IGI_CIS_AWT_TAX_RATES 12.1.1

IGI - Public Sector Financials International·60 columns

Displays CIS WIthholding Certificate records coupled with NI Number details.

APPS.IGI_CIS_AWT_TAX_RATES·↳ AP_AWT_TAX_RATES·↳ IGI_CIS_CERT_NI_NUMBERS·Explore IGI module →

View: AR_CASH_RECEIPTS_ALL_MRC_V 12.1.1

AR - Receivables·104 columns

APPS.AR_CASH_RECEIPTS_ALL_MRC_V·↳ AR_CASH_RECEIPTS_ALL·↳ AR_MC_CASH_RECEIPTS·Explore AR module →

Table: SO_HEADER_ATTRIBUTES_INTERFACE 12.1.1 standalone

owner OE·OE - Order Entry·35 columns

Additional attributes of imported order headers

OE.SO_HEADER_ATTRIBUTES_INTERFACE·Explore OE module →

View: HR_LOCATIONS_NO_JOIN 12.2.2

PER - Human Resources·87 columns

USed to support user interface.

APPS.HR_LOCATIONS_NO_JOIN·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore PER module →

View: JTF_CUST_ACCT_SITES_V 12.1.1

JTF - CRM Foundation·72 columns

JTF_CUST_ACCT_SITES retrieves information about customer sites. One customer account can have multiple sites.

APPS.JTF_CUST_ACCT_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·Explore JTF module →

View: AR_CUSTOMERS 12.2.2

AR - Receivables·79 columns

(Release 11.5 Only)

APPS.AR_CUSTOMERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →

View: JTF_HZ_ORGANIZATION_PROFILES_V 12.2.2

JTF - CRM Foundation·114 columns

JTF_HZ_ORGANIZATION_PROFILES_V retrieves information about people as contacts for organizations. The table includes information about the person in the context of the organization such as their job title or rank.

APPS.JTF_HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore JTF module →

View: PO_HEADERS_TRX_V 12.2.2

PO - Purchasing·190 columns

View on po_headers table.

APPS.PO_HEADERS_TRX_V·↳ PO_HEADERS·Explore PO module →

View: AR_CUSTOMERS 12.1.1

AR - Receivables·79 columns

(Release 11.5 Only)

APPS.AR_CUSTOMERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →

View: AR_REMIT_TO_ADDRESSES_V 12.1.1

AR - Receivables·86 columns

(Release 11.5 Only)