[Home] [Help] [Dependency Information]
Object Name: | GMF_XLA_PAYABLES_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMF.GMF_XLA_PAYABLES_INVOICES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for SLA ADR sources from Payable Invoices
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | Yes | Legal Entity | |
LEDGER_ID | NUMBER | Yes | Ledger Identifier | |
TRANSACTION_ID | NUMBER | Yes | Transaction Identifier from MTL_MATERIAL_TRANSACTIONS table | |
VALUATION_COST_TYPE_ID | NUMBER | Yes | Valuation Cost Type Identifier | |
COST_TYPE_CODE | VARCHAR2 | (50) | Valuation Cost Type Code | |
EVENT_CLASS_CODE | VARCHAR2 | (50) | Yes | Event Class Code |
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Yes | Legal Entity Name |
ITEM_NAME | VARCHAR2 | (40) | Item Name | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
ACCOUNTED_DATE | DATE | Accounted Date | ||
PRIMARY_QUANTITY | NUMBER | Yes | Primary Quantity | |
TRANSACTION_UOM | VARCHAR2 | (50) | Yes | Transaction Uom |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Uom Code | |
SECONDARY_UOM_CODE | VARCHAR2 | (3) | Secondary Uom Code | |
CALENDAR_CODE | VARCHAR2 | (10) | Yes | Calendar Code |
PERIOD_CODE | VARCHAR2 | (10) | Yes | Period Code |
PERIOD_STATUS | VARCHAR2 | (6) | Period Status | |
AMOUNT | NUMBER | Amount | ||
VARIANCE_TYPE | VARCHAR2 | (26) | Variance Type |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_ENTITY_ID
, LEDGER_ID
, TRANSACTION_ID
, VALUATION_COST_TYPE_ID
, COST_TYPE_CODE
, EVENT_CLASS_CODE
, LEGAL_ENTITY_NAME
, ITEM_NAME
, ITEM_DESCRIPTION
, ORGANIZATION_CODE
, ACCOUNTED_DATE
, PRIMARY_QUANTITY
, TRANSACTION_UOM
, PRIMARY_UOM_CODE
, SECONDARY_UOM_CODE
, CALENDAR_CODE
, PERIOD_CODE
, PERIOD_STATUS
, AMOUNT
, VARIANCE_TYPE
FROM APPS.GMF_XLA_PAYABLES_INVOICES_V;
APPS.GMF_XLA_PAYABLES_INVOICES_V is not referenced by any database object
|
|
|