EC Views (51)
EC - e-Commerce Gateway — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| View | Description |
|---|---|
ECE_ADDRESS_TP |
|
ECE_ADVO_DETAILS_V |
This view extracts advice detailsfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycl |
ECE_ADVO_HEADERS_V |
This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@r |
ECE_ATTACHMENT_V |
/*#* This view extracts attachment data* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) trans |
ECE_CDMO_ALLOWANCE_CHARGES_V |
This view extracts allowance and charges informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.The allowance and cha |
ECE_CDMO_HEADER_1_V |
This view extracts additional header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:pr |
ECE_CDMO_HEADER_V |
This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@re |
ECE_CDMO_LINE_TAX_V |
This view extracts line tax informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@ |
ECE_CDMO_LINE_V |
This view extracts line informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep: |
ECE_CDMO_TRX_NUMBER_V |
Contains the credit/debit memo number for the customer for outbound Credit/Debit Memo (812 - CREADV / DEBADV) transaction. |
ECE_CONTACT_PHONE |
|
ECE_CUSTOMER_PHONE |
|
ECE_DSNO_ALLOWANCE_CHARGES_V |
No longer used |
ECE_DSNO_CONTAINERS_V |
No longer used |
ECE_DSNO_DELIVERIES_V |
No longer used |
ECE_DSNO_DELIVERY_ATTRIBS_V |
No longer used |
ECE_DSNO_ITEMS_V |
No longer used |
ECE_DSNO_ITEM_DETAILS_V |
No longer used |
ECE_DSNO_ORDERS_V |
No longer used |
ECE_DSNO_PACKED_QUANTITY_V |
No longer used |
ECE_INO_ALLOWANCE_CHARGES_V |
This view extracts allowance and charge informationfor the outbound Invoice (810/INVOIC) transaction.The allowance and charges view is used |
ECE_INO_HEADER_1_V |
This view extracts additional header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:life |
ECE_INO_HEADER_V |
This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle activ |
ECE_INO_LINE_TAX_V |
This view extracts line tax informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle act |
ECE_LOOKUP_VALUES |
View of FND_LOOKUP_VALUES table. |
ECE_MTL_MOV_STAT_V |
Contains the movement type information for documents with EDI transactions pending. |
ECE_MVSTO_DETAILS_V |
This view extracts line informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifec |
ECE_MVSTO_HEADERS_V |
This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lif |
ECE_MVSTO_LOCATIONS_V |
This view extracts line location informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@ |
ECE_POCO_HEADERS_V |
This view extracts header informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:l |
ECE_POCO_LINES_V |
This view extracts line informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lif |
ECE_POCO_SHIPMENTS_V |
This view extracts shipment informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep |
ECE_POO_HEADERS_V |
/*#* This view extracts header information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO |
ECE_POO_LINES_V |
/*#* This view extracts line information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @r |
ECE_POO_SHIPMENTS_V |
/*#* This view extracts shipment information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO |
ECE_PO_DISTRIBUTIONS_V |
/*#* This view extracts distribution information* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDC |
ECE_PO_PROJECT_INFO_V |
Contains the project level data for the the Purchase Order (850/ORDERS) and the Purchase Order Changes (860/ORDCHG) transactions. |
ECE_PRIMARY_CONTACT_PHONE_V |
|
ECE_PRIMARY_CUSTOMER_PHONE_V |
|
ECE_PROFILE_OPTIONS |
View on FND_PROFILE_OPTIONS_VL and FND_PROFILE_OPTIONS_VALUES tables |
ECE_PYO_INVOICE_V |
This view extracts invoices selected for payment to supportthe outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep |
ECE_PYO_PAYMENT_V |
This view extracts payment informationfor the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@re |
ECE_RCO_ADDRESS |
|
ECE_RSU_CONTACT |
|
ECE_RSU_NOCONTACT |
|
ECE_SPSO_HEADERS_V |
This view extracts header informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:life |
ECE_SPSO_ITEMS_V |
This view extracts item informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecy |
ECE_SSSO_HEADERS_V |
This view extracts header informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:life |
ECE_SSSO_ITEMS_V |
This view extracts item informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecy |
ECE_STAGE_LEVEL1_V |
ECE_STAGE_LEVEL1_V is used in ECERNCON.fmb to retrieve the |
ECE_STAGE_LEVEL2_V |
ECE_STAGE_LEVEL2_V is used in ECERNCON.fmb to retrieve |