PACKAGE BODY: APPS.ONT_OEXOECOD_XMLP_PKG

PACKAGE BODY: APPS.ONT_OEXOECOD_XMLP_PKG 12.1.1

PACKAGE: APPS.ONT_OEXOECOD_XMLP_PKG 12.1.1

PACKAGE: APPS.ONT_OEXOECOD_XMLP_PKG 12.2.2

PACKAGE BODY: APPS.ONT_OEXOECOD_XMLP_PKG 12.2.2

View: AR_CUSTOMER_SEARCH_V 12.2.2

AR - Receivables·10 columns

APPS.AR_CUSTOMER_SEARCH_V·↳ ARP_ADDR_PKG·↳ AR_ADDRESSES_V·↳ HZ_CUST_ACCOUNTS·Explore AR module →

View: ARI_CUSTOMER_SEARCH_V 12.2.2

AR - Receivables·11 columns

APPS.ARI_CUSTOMER_SEARCH_V·↳ ARP_ADDR_PKG·↳ FND_TERRITORIES_TL·↳ HZ_CUST_ACCOUNTS·Explore AR module →

View: ARI_CUSTOMER_SEARCH_V 12.1.1

AR - Receivables·11 columns

APPS.ARI_CUSTOMER_SEARCH_V·↳ ARP_ADDR_PKG·↳ FND_TERRITORIES_TL·↳ HZ_CUST_ACCOUNTS·Explore AR module →

Table: AR_CUST_SEARCH_GT_ALL 12.2.2

owner AR·AR - Receivables·12 columns

AR.AR_CUST_SEARCH_GT_ALL·Explore AR module →

View: CS_SR_CONTACT_POINTS_V 12.2.2

CS - Service·21 columns

This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts.

APPS.CS_SR_CONTACT_POINTS_V·↳ AR_LOOKUPS·↳ CS_HZ_SR_CONTACT_POINTS·↳ HZ_CONTACT_POINTS·Explore CS module →

View: ITG_SP_PO_PART_SOLDTO_V 12.2.2

ITG - Internet Procurement Enterprise Connector·27 columns

This view is used to generate partner sold to segment in Sync PO XML

APPS.ITG_SP_PO_PART_SOLDTO_V·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore ITG module →

View: ITG_SP_REL_PART_SHIPTO_V 12.1.1

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate partner shipto segment for the PO release XML

APPS.ITG_SP_REL_PART_SHIPTO_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

View: ITG_SP_REL_LINE_PART_EMPL_V 12.2.2

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate partner employee segment at po release line level.

APPS.ITG_SP_REL_LINE_PART_EMPL_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

View: ITG_SP_PO_LINE_PART_EMPL_V 12.2.2

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate the partner employee XML segment in the PO line for Sync PO

APPS.ITG_SP_PO_LINE_PART_EMPL_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

View: ITG_SP_PO_PART_SHIPTO_V 12.1.1

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate partner ship-to segment in Sync PO XML

APPS.ITG_SP_PO_PART_SHIPTO_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

View: AR_CUSTOMER_SEARCH_V 12.1.1

AR - Receivables·10 columns

APPS.AR_CUSTOMER_SEARCH_V·↳ ARP_ADDR_PKG·↳ AR_ADDRESSES_V·↳ HZ_CUST_ACCOUNTS·Explore AR module →

View: GHR_POIS_V 12.1.1

GHR - US Federal Human Resources·19 columns

GHR_POIS_V is based on secure view PER_PEOPLE_V and used by POI form.

APPS.GHR_POIS_V·↳ GHR_GROUPBOXES·↳ GHR_POIS·↳ HR_GENERAL·Explore GHR module →

Table: FA_DEPRN_TAX_ENTITIES 12.1.1 standalone

owner FA·OFA - Assets·21 columns

FA.FA_DEPRN_TAX_ENTITIES·Explore OFA module →

View: PN_LOCATIONS_ITF_V 12.2.2

PN - Property Manager·67 columns

APPS.PN_LOCATIONS_ITF_V·↳ PN_ADDRESSES_ALL·↳ PN_CONTACTS_ALL·↳ PN_CONTACT_ASSIGNMENTS_ALL·Explore PN module →

Table: GHR_POIS 12.1.1 hub-leaning

owner HR·GHR - US Federal Human Resources·16 columns

Contains information related to Personnel Office Identifier

HR.GHR_POIS·Explore GHR module →

View: CS_SR_CONTACT_POINTS_V 12.1.1

CS - Service·16 columns

This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts.

APPS.CS_SR_CONTACT_POINTS_V·↳ AR_LOOKUPS·↳ CS_HZ_SR_CONTACT_POINTS·↳ HZ_CONTACT_POINTS·Explore CS module →

View: ITG_SP_PO_PART_SOLDTO_V 12.1.1

ITG - Internet Procurement Enterprise Connector·27 columns

This view is used to generate partner sold to segment in Sync PO XML

APPS.ITG_SP_PO_PART_SOLDTO_V·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore ITG module →

View: ITG_SP_REL_PART_SOLDTO_V 12.2.2

ITG - Internet Procurement Enterprise Connector·27 columns

This view is used to generate the partner sold to segment in the PO release XML

APPS.ITG_SP_REL_PART_SOLDTO_V·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore ITG module →

View: ITG_SP_REL_PART_SHIPTO_V 12.2.2

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate partner shipto segment for the PO release XML

APPS.ITG_SP_REL_PART_SHIPTO_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

Table: GHR_POIS 12.2.2 hub

owner HR·GHR - US Federal Human Resources·17 columns

Contains information related to Personnel Office Identifier

HR.GHR_POIS·Explore GHR module →

View: OKX_RCPT_METHOD_ACCOUNTS_V 12.2.2

OKX - Contracts Integration·29 columns

This view contains bank accounts for customers

APPS.OKX_RCPT_METHOD_ACCOUNTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_SITE_USES_ALL·Explore OKX module →

Table: FA_DEPRN_TAX_ENTITIES 12.2.2 standalone

owner FA·OFA - Assets·23 columns

FA_DEPRN_TAX_ENTITIES table is used to store company-level information required by Japanese Depreciable Assets Tax Reports.

FA.FA_DEPRN_TAX_ENTITIES·Explore OFA module →

View: GHR_POIS_V 12.2.2

GHR - US Federal Human Resources·19 columns

GHR_POIS_V is based on secure view PER_PEOPLE_V and used by POI form.

APPS.GHR_POIS_V·↳ GHR_GROUPBOXES·↳ GHR_POIS·↳ HR_GENERAL·Explore GHR module →

View: OKX_RCPT_METHOD_ACCOUNTS_V 12.1.1

OKX - Contracts Integration·26 columns

This view contains bank accounts for customers

APPS.OKX_RCPT_METHOD_ACCOUNTS_V·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_PARTIES·↳ IBY_CREDITCARD·Explore OKX module →

View: ITG_SP_REL_PART_SUPPL_V 12.2.2

ITG - Internet Procurement Enterprise Connector·37 columns

This view is used to generate the partner supplier segment in the po release XML

APPS.ITG_SP_REL_PART_SUPPL_V·↳ FND_GLOBAL·↳ PO_HEADERS_ALL·↳ PO_VENDORS·Explore ITG module →

View: ITG_SP_PO_PART_SHIPTO_V 12.2.2

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate partner ship-to segment in Sync PO XML

APPS.ITG_SP_PO_PART_SHIPTO_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

Table: AR_AGING_EXTRACT 12.2.2 standalone

owner AR·AR - Receivables·37 columns

Temporary table used in MFAR aging report process

AR.AR_AGING_EXTRACT·Explore AR module →

View: CEBV_BANK_ACCOUNTS 12.1.1

CE - Cash Management·29 columns

Business view

APPS.CEBV_BANK_ACCOUNTS·↳ CE_BANK_ACCOUNTS·↳ IBY_EXT_BANK_ACCOUNTS_V·Explore CE module →

Table: IBY_TEMP_EXT_BANK_ACCTS 12.2.2 standalone

owner IBY·IBY - Payments·73 columns

IBY.IBY_TEMP_EXT_BANK_ACCTS·Explore IBY module →

View: CEFV_BANK_ACCOUNTS 12.2.2

CE - Cash Management·31 columns

Business view

APPS.CEFV_BANK_ACCOUNTS·↳ CE_BANK_ACCOUNTS·↳ IBY_EXT_BANK_ACCOUNTS_V·Explore CE module →

View: CEFV_BANK_ACCOUNTS 12.1.1

CE - Cash Management·31 columns

Business view

APPS.CEFV_BANK_ACCOUNTS·↳ CE_BANK_ACCOUNTS·↳ IBY_EXT_BANK_ACCOUNTS_V·Explore CE module →

View: ITG_SP_REL_PART_SOLDTO_V 12.1.1

ITG - Internet Procurement Enterprise Connector·27 columns

This view is used to generate the partner sold to segment in the PO release XML

APPS.ITG_SP_REL_PART_SOLDTO_V·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore ITG module →

Table: OKL_OPEN_INT_ALL 12.1.1 standalone

owner OKL·OKL - Leasing and Finance Management·82 columns

Open Interface for report to credit bureau/transfer to external agency

OKL.OKL_OPEN_INT_ALL·Explore OKL module →

Table: CE_UPG_AP_ACCTS_TMP 12.2.2 satellite-leaning

owner CE·CE - Cash Management·105 columns

This table stores AP purged bank account details

CE.CE_UPG_AP_ACCTS_TMP·Explore CE module →

View: ITG_SP_PO_LINE_PART_EMPL_V 12.1.1

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate the partner employee XML segment in the PO line for Sync PO

APPS.ITG_SP_PO_LINE_PART_EMPL_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

View: ITG_SP_REL_LINE_PART_EMPL_V 12.1.1

ITG - Internet Procurement Enterprise Connector·28 columns

This view is used to generate partner employee segment at po release line level.

APPS.ITG_SP_REL_LINE_PART_EMPL_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore ITG module →

View: ITG_SP_REL_PART_SUPPL_V 12.1.1

ITG - Internet Procurement Enterprise Connector·37 columns

This view is used to generate the partner supplier segment in the po release XML

APPS.ITG_SP_REL_PART_SUPPL_V·↳ PO_HEADERS_ALL·↳ PO_VENDORS·↳ PO_VENDOR_CONTACTS·Explore ITG module →

View: CEBV_BANK_ACCOUNTS 12.2.2

CE - Cash Management·29 columns

Business view

APPS.CEBV_BANK_ACCOUNTS·↳ CE_BANK_ACCOUNTS·↳ IBY_EXT_BANK_ACCOUNTS_V·Explore CE module →

View: ITG_SP_PO_PART_SUPPL_V 12.2.2

ITG - Internet Procurement Enterprise Connector·37 columns

This view is used to generate the partner supplier segment in the Sync PO XML

APPS.ITG_SP_PO_PART_SUPPL_V·↳ FND_GLOBAL·↳ PO_HEADERS_ALL·↳ PO_VENDORS·Explore ITG module →

View: ITG_SP_PO_PART_SUPPL_V 12.1.1

ITG - Internet Procurement Enterprise Connector·37 columns

This view is used to generate the partner supplier segment in the Sync PO XML

APPS.ITG_SP_PO_PART_SUPPL_V·↳ PO_HEADERS_ALL·↳ PO_VENDORS·↳ PO_VENDOR_CONTACTS·Explore ITG module →

Table: DPP_TRANSACTION_HEADERS_LOG 12.1.1 standalone

owner DPP·DPP - Oracle Price Protection·52 columns

This table will store history information for changes done to the Price Protection Transaction Header.

DPP.DPP_TRANSACTION_HEADERS_LOG·Explore DPP module →

Table: DPP_TRANSACTION_HEADERS_LOG 12.2.2 standalone

owner DPP·DPP - Oracle Price Protection·52 columns

This table will store history information for changes done to the Price Protection Transaction Header.

DPP.DPP_TRANSACTION_HEADERS_LOG·Explore DPP module →

Table: AP_BANK_ACCOUNTS_ALL 12.2.2 hub

owner AP·AP - Payables·105 columns

AP.AP_BANK_ACCOUNTS_ALL·Explore AP module →

Table: CSP_PLANNING_PARAMETERS 12.2.2 satellite-leaning

owner CSP·CSP - Spares Management·108 columns

Planning Parameters Definition

CSP.CSP_PLANNING_PARAMETERS·Explore CSP module →

Table: POS_SUP_BANK_ACCOUNT_REQUESTS 12.2.2 satellite-leaning

owner POS·POS - iSupplier Portal·43 columns

This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12.

POS.POS_SUP_BANK_ACCOUNT_REQUESTS·Explore POS module →

Table: OP_CUST_CON 12.1.1 hub-leaning

owner GML·GML - Process Manufacturing Logistics·54 columns

Customer contact information.

GML.OP_CUST_CON·Explore GML module →

Results for “contact_phone”