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

VIEW: APPS.PMITS_FINAL_SUBLEDGER_V

Object Details
Object Name: PMITS_FINAL_SUBLEDGER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMITS_FINAL_SUBLEDGER_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
SOURCE NUMBER

SUBLEDGER_ID NUMBER (10)
Subsidiary ledger key.
CO_CODE VARCHAR2 (4)
Company of transaction.
FISCAL_YEAR NUMBER (5)
Fiscal year of gl posting.
PERIOD NUMBER (5)
Period of gl posting.
SUB_EVENT_CODE VARCHAR2 (4)
VOUCHER_ID NUMBER (10)
GL journal voucher identifier.
DOC_TYPE VARCHAR2 (4)
Document type.
DOC_ID NUMBER (10)
Document identifier within doc type.
JOIN_DOC_ID NUMBER

This will have actual Document id for XFER,TRNI,TRNR,MTRI
LINE_ID NUMBER (10)
Detail line identifier.
ACCT_TTL_CODE VARCHAR2 (4)
ACCTG_UNIT_NO VARCHAR2 (240)
OPM Accounting unit Description.
ACCT_NO VARCHAR2 (240)
OPM Account Description.
DEBIT_CREDIT_SIGN NUMBER (5)
Debit or Credit indicator for the Amounts: -1=credit; =1=debit.
ACCTG_UNIT_DESC VARCHAR2 (70)
ACCT_DESC VARCHAR2 (70)
AMOUNT_BASE NUMBER

GL amount in Base currency.
AMOUNT_TRANS NUMBER

GL amount in Transaction currency.
CURRENCY_BASE VARCHAR2 (4)
Base currency of transaction.
CURRENCY_TRANS VARCHAR2 (4)
Currency of transaction.
JV_QUANTITY NUMBER

Quantity of GL Account.
JV_QUANTITY_UM VARCHAR2 (4)
Unit of measure of quantity.
SUB_EVENT_DESC VARCHAR2 (70)
Sub Event Description.
TRANS_SOURCE_CODE VARCHAR2 (4)
Abbreviation assigned to subsystem
TRANS_SOURCE_DESC VARCHAR2 (70)
subsystem description
GL_TRANS_DATE DATE

GL transaction date.
ORGN_CODE VARCHAR2 (16)
Organization of transaction.
DOC_NO VARCHAR2 (40)
Document Number.
DOC_DATE DATE

Document Transaction Date.
LINE_NO VARCHAR2 (150)
Detail line Number.
RESOURCE_ITEM_NO VARCHAR2 (32)
Item Number.
RESOURCE_ITEM_NO_DESC VARCHAR2 (70)
Item Description.
TRANS_DATE DATE

Transaction Date.
WHSE_CODE VARCHAR2 (4)
Warehouse Code
TRANS_QTY_USAGE NUMBER

Transaction Qty Usage
TRANS_QTY_USAGE_UM VARCHAR2 (25)
Transaction Qty Usage UOM
REFERENCE_NO NUMBER (10)
The Subsidiary Ledger Run reference number.
TRANS_TYPE VARCHAR2 (11)
Transaction Type. This column is used to join subsidiary ledger data with inventory data
Name Datatype Length Mandatory Comments
Query Text

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


SELECT SOURCE
,      SUBLEDGER_ID
,      CO_CODE
,      FISCAL_YEAR
,      PERIOD
,      SUB_EVENT_CODE
,      VOUCHER_ID
,      DOC_TYPE
,      DOC_ID
,      JOIN_DOC_ID
,      LINE_ID
,      ACCT_TTL_CODE
,      ACCTG_UNIT_NO
,      ACCT_NO
,      DEBIT_CREDIT_SIGN
,      ACCTG_UNIT_DESC
,      ACCT_DESC
,      AMOUNT_BASE
,      AMOUNT_TRANS
,      CURRENCY_BASE
,      CURRENCY_TRANS
,      JV_QUANTITY
,      JV_QUANTITY_UM
,      SUB_EVENT_DESC
,      TRANS_SOURCE_CODE
,      TRANS_SOURCE_DESC
,      GL_TRANS_DATE
,      ORGN_CODE
,      DOC_NO
,      DOC_DATE
,      LINE_NO
,      RESOURCE_ITEM_NO
,      RESOURCE_ITEM_NO_DESC
,      TRANS_DATE
,      WHSE_CODE
,      TRANS_QTY_USAGE
,      TRANS_QTY_USAGE_UM
,      REFERENCE_NO
,      TRANS_TYPE
FROM APPS.PMITS_FINAL_SUBLEDGER_V;

Dependencies

[top of page]

APPS.PMITS_FINAL_SUBLEDGER_V references the following:

SchemaAPPS
ViewGL_SUBR_LED_VW
PL/SQL PackagePMI_SECURITY_PKG - show dependent code

APPS.PMITS_FINAL_SUBLEDGER_V is not referenced by any database object