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

VIEW: APPS.PMITS_TEST_SUBLEDGER_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE NUMBER

SUBLEDGER_ID NUMBER

Subsidiary ledger key.
CO_CODE VARCHAR2 (4)
Company of transaction.
FISCAL_YEAR NUMBER

Fiscal year of gl posting.
PERIOD NUMBER

Period of gl posting.
SUB_EVENT_CODE VARCHAR2 (4)
VOUCHER_ID NUMBER

GL journal voucher identifier.
DOC_TYPE VARCHAR2 (4)
Document type.
DOC_ID NUMBER

Document identifier within doc type.
JOIN_DOC_ID NUMBER

This will have actual Document id for XFER,TRNI,TRNR,MTRI
LINE_ID NUMBER

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

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

The Subsidiary Ledger Run reference number.
TRANS_TYPE VARCHAR2 (11)
Transaction Type. This column is used to join subsidiary ledger data with inventory data
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_TEST_SUBLEDGER_V;

Dependencies

[top of page]

APPS.PMITS_TEST_SUBLEDGER_V references the following:

SchemaAPPS
ViewGL_SUBR_TST_VW
PL/SQL PackagePMI_SECURITY_PKG - show dependent code

APPS.PMITS_TEST_SUBLEDGER_V is not referenced by any database object