DBA Data[Home] [Help] [Dependency Information]

TABLE: APPS.POA_IDL_BS_J_MV

Object Details
Object Name: POA_IDL_BS_J_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_IDL_BS_J_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UMARKER NUMBER

Union Operator Marker
FRID ROWID (10)
FRID
VRID ROWID (10)
VRID
VSRID ROWID (10)
VSRID
CRID ROWID (10)
CRID
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
INV_D_CREATED_BY NUMBER (15)
Invoice Distribution Creator Identifier
COMPANY_ID NUMBER (15)
Company Identifier (Local Value Set)
COST_CENTER_ID NUMBER (15)
Cost center Identifier (Local Value Set)
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
AMOUNT_B NUMBER

Invoice Amount in Functional Currency
AMOUNT_G NUMBER

Invoice Amount in Global Currency
AMOUNT_SG NUMBER

Invoice Amount in Secondary Global Currency
PO_MATCHED_FLAG VARCHAR2 (1)
Flag if Invoice is PO Matched or not
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be received before the invoice is paid
Query Text

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


SELECT UMARKER
,      FRID
,      VRID
,      VSRID
,      CRID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      INV_D_CREATED_BY
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AMOUNT_B
,      AMOUNT_G
,      AMOUNT_SG
,      PO_MATCHED_FLAG
,      RECEIPT_REQUIRED_FLAG
FROM APPS.POA_IDL_BS_J_MV;

Dependencies

[top of page]

APPS.POA_IDL_BS_J_MV does not reference any database object

APPS.POA_IDL_BS_J_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_IDL_001_MV
Materialized ViewPOA_IDL_BS_J_MV
Materialized ViewPOA_IDL_BS_MV