eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TYPE: APPS.PO_DISTRIBUTIONS_VAL_TYPE

Object Details

Object Name:	PO_DISTRIBUTIONS_VAL_TYPE
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
DRAFT_ID	PO_TBL_NUMBER
CHANGE_ACCEPTED_FLAG	PO_TBL_VARCHAR1
DELETE_FLAG	PO_TBL_VARCHAR1
PO_DISTRIBUTION_ID	PO_TBL_NUMBER
LAST_UPDATE_DATE	PO_TBL_DATE
LAST_UPDATED_BY	PO_TBL_NUMBER
PO_HEADER_ID	PO_TBL_NUMBER
PO_LINE_ID	PO_TBL_NUMBER
LINE_LOCATION_ID	PO_TBL_NUMBER
SET_OF_BOOKS_ID	PO_TBL_NUMBER
CODE_COMBINATION_ID	PO_TBL_NUMBER
QUANTITY_ORDERED	PO_TBL_NUMBER
LAST_UPDATE_LOGIN	PO_TBL_NUMBER
CREATION_DATE	PO_TBL_DATE
CREATED_BY	PO_TBL_NUMBER
PO_RELEASE_ID	PO_TBL_NUMBER
QUANTITY_DELIVERED	PO_TBL_NUMBER
QUANTITY_BILLED	PO_TBL_NUMBER
QUANTITY_CANCELLED	PO_TBL_NUMBER
REQ_HEADER_REFERENCE_NUM	PO_TBL_VARCHAR30
REQ_LINE_REFERENCE_NUM	PO_TBL_VARCHAR30
REQ_DISTRIBUTION_ID	PO_TBL_NUMBER
DELIVER_TO_LOCATION_ID	PO_TBL_NUMBER
DELIVER_TO_PERSON_ID	PO_TBL_NUMBER
RATE_DATE	PO_TBL_DATE
RATE	PO_TBL_NUMBER
AMOUNT_BILLED	PO_TBL_NUMBER
ACCRUED_FLAG	PO_TBL_VARCHAR1
ENCUMBERED_FLAG	PO_TBL_VARCHAR1
ENCUMBERED_AMOUNT	PO_TBL_NUMBER
UNENCUMBERED_QUANTITY	PO_TBL_NUMBER
UNENCUMBERED_AMOUNT	PO_TBL_NUMBER
FAILED_FUNDS_LOOKUP_CODE	PO_TBL_VARCHAR30
GL_ENCUMBERED_DATE	PO_TBL_DATE
GL_ENCUMBERED_PERIOD_NAME	PO_TBL_VARCHAR30
GL_CANCELLED_DATE	PO_TBL_DATE
DESTINATION_TYPE_CODE	PO_TBL_VARCHAR30
DESTINATION_ORGANIZATION_ID	PO_TBL_NUMBER
DESTINATION_SUBINVENTORY	PO_TBL_VARCHAR30
ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR30
ATTRIBUTE1	PO_TBL_VARCHAR2000
ATTRIBUTE2	PO_TBL_VARCHAR2000
ATTRIBUTE3	PO_TBL_VARCHAR2000
ATTRIBUTE4	PO_TBL_VARCHAR2000
ATTRIBUTE5	PO_TBL_VARCHAR2000
ATTRIBUTE6	PO_TBL_VARCHAR2000
ATTRIBUTE7	PO_TBL_VARCHAR2000
ATTRIBUTE8	PO_TBL_VARCHAR2000
ATTRIBUTE9	PO_TBL_VARCHAR2000
ATTRIBUTE10	PO_TBL_VARCHAR2000
ATTRIBUTE11	PO_TBL_VARCHAR2000
ATTRIBUTE12	PO_TBL_VARCHAR2000
ATTRIBUTE13	PO_TBL_VARCHAR2000
ATTRIBUTE14	PO_TBL_VARCHAR2000
ATTRIBUTE15	PO_TBL_VARCHAR2000
WIP_ENTITY_ID	PO_TBL_NUMBER
WIP_OPERATION_SEQ_NUM	PO_TBL_NUMBER
WIP_RESOURCE_SEQ_NUM	PO_TBL_NUMBER
WIP_REPETITIVE_SCHEDULE_ID	PO_TBL_NUMBER
WIP_LINE_ID	PO_TBL_NUMBER
BOM_RESOURCE_ID	PO_TBL_NUMBER
BUDGET_ACCOUNT_ID	PO_TBL_NUMBER
ACCRUAL_ACCOUNT_ID	PO_TBL_NUMBER
VARIANCE_ACCOUNT_ID	PO_TBL_NUMBER
PREVENT_ENCUMBRANCE_FLAG	PO_TBL_VARCHAR1
USSGL_TRANSACTION_CODE	PO_TBL_VARCHAR30
GOVERNMENT_CONTEXT	PO_TBL_VARCHAR30
DESTINATION_CONTEXT	PO_TBL_VARCHAR30
DISTRIBUTION_NUM	PO_TBL_NUMBER
SOURCE_DISTRIBUTION_ID	PO_TBL_NUMBER
REQUEST_ID	PO_TBL_NUMBER
PROGRAM_APPLICATION_ID	PO_TBL_NUMBER
PROGRAM_ID	PO_TBL_NUMBER
PROGRAM_UPDATE_DATE	PO_TBL_DATE
PROJECT_ID	PO_TBL_NUMBER
TASK_ID	PO_TBL_NUMBER
EXPENDITURE_TYPE	PO_TBL_VARCHAR30
PROJECT_ACCOUNTING_CONTEXT	PO_TBL_VARCHAR30
EXPENDITURE_ORGANIZATION_ID	PO_TBL_NUMBER
GL_CLOSED_DATE	PO_TBL_DATE
ACCRUE_ON_RECEIPT_FLAG	PO_TBL_VARCHAR1
EXPENDITURE_ITEM_DATE	PO_TBL_DATE
ORG_ID	PO_TBL_NUMBER
KANBAN_CARD_ID	PO_TBL_NUMBER
AWARD_ID	PO_TBL_NUMBER
MRC_RATE_DATE	PO_TBL_VARCHAR2000
MRC_RATE	PO_TBL_VARCHAR2000
MRC_ENCUMBERED_AMOUNT	PO_TBL_VARCHAR2000
MRC_UNENCUMBERED_AMOUNT	PO_TBL_VARCHAR2000
END_ITEM_UNIT_NUMBER	PO_TBL_VARCHAR30
TAX_RECOVERY_OVERRIDE_FLAG	PO_TBL_VARCHAR1
RECOVERABLE_TAX	PO_TBL_NUMBER
NONRECOVERABLE_TAX	PO_TBL_NUMBER
RECOVERY_RATE	PO_TBL_NUMBER
OKE_CONTRACT_LINE_ID	PO_TBL_NUMBER
OKE_CONTRACT_DELIVERABLE_ID	PO_TBL_NUMBER
AMOUNT_ORDERED	PO_TBL_NUMBER
AMOUNT_DELIVERED	PO_TBL_NUMBER
AMOUNT_CANCELLED	PO_TBL_NUMBER
DISTRIBUTION_TYPE	PO_TBL_VARCHAR30
AMOUNT_TO_ENCUMBER	PO_TBL_NUMBER
INVOICE_ADJUSTMENT_FLAG	PO_TBL_VARCHAR1
DEST_CHARGE_ACCOUNT_ID	PO_TBL_NUMBER
DEST_VARIANCE_ACCOUNT_ID	PO_TBL_NUMBER
QUANTITY_FINANCED	PO_TBL_NUMBER
AMOUNT_FINANCED	PO_TBL_NUMBER
QUANTITY_RECOUPED	PO_TBL_NUMBER
AMOUNT_RECOUPED	PO_TBL_NUMBER
RETAINAGE_WITHHELD_AMOUNT	PO_TBL_NUMBER
RETAINAGE_RELEASED_AMOUNT	PO_TBL_NUMBER
AWARD_NUMBER	PO_TBL_VARCHAR2000
ACRN	PO_TBL_VARCHAR30
PARTIAL_FUNDED_FLAG	PO_TBL_VARCHAR1
FUNDED_VALUE	PO_TBL_NUMBER
QUANTITY_FUNDED	PO_TBL_NUMBER
AMOUNT_FUNDED	PO_TBL_NUMBER
HDR_AGENT_ID	PO_TBL_NUMBER
STYLE_ID	PO_TBL_NUMBER
LINE_ORDER_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
LINE_ITEM_ID	PO_TBL_NUMBER
LINE_LINE_TYPE_ID	PO_TBL_NUMBER
LINE_PURCHASE_BASIS	PO_TBL_VARCHAR30
LINE_COST_CONSTRAINT	PO_TBL_VARCHAR30
LINE_MATCHING_BASIS	PO_TBL_VARCHAR30
DRAFT_TYPE	PO_TBL_VARCHAR30
SHIP_TO_ORGANIZATION_ID	PO_TBL_NUMBER
SHIP_VALUE_BASIS	PO_TBL_VARCHAR30
PRICE_OVERRIDE	PO_TBL_NUMBER
HEADER_NEED_BY_DATE	PO_TBL_DATE
PROMISED_DATE	PO_TBL_DATE
INTERFACE_ID	PO_TBL_NUMBER
EXPENSE_ACCRUAL_CODE	PO_TBL_VARCHAR30
LOC_OUTSOURCED_ASSEMBLY	PO_TBL_NUMBER
TRANSACTION_FLOW_HEADER_ID	PO_TBL_NUMBER
INTF_LINE_ID	PO_TBL_NUMBER
CLM_DEFENCE_FUNDING	PO_TBL_VARCHAR30
CLMMISC_LOA	PO_TBL_VARCHAR240
OLD_QUANTITY_ORDERED	PO_TBL_NUMBER
PAR_DRAFT_ID	PO_TBL_VARCHAR4000
CHANGE_STATUS	PO_TBL_VARCHAR30

Methods

Name	Parameters	Result
PO_DISTRIBUTIONS_VAL_TYPE	SELF(PO_DISTRIBUTIONS_VAL_TYPE)	PO_DISTRIBUTIONS_VAL_TYPE

Dependencies

[top of page]

APPS.PO_DISTRIBUTIONS_VAL_TYPE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR1; PO_TBL_VARCHAR2000; PO_TBL_VARCHAR240; PO_TBL_VARCHAR30; PO_TBL_VARCHAR4000

APPS.PO_DISTRIBUTIONS_VAL_TYPE is referenced by following:

APPS: PO_DISTRIBUTIONS_VAL_TYPE; PO_MOD_SYNC_PROCESS_PVT - show dependent code; PO_PDOI_DIST_PROCESS_PVT - show dependent code; PO_VALIDATIONS - show dependent code; PO_VALIDATIONS - show dependent code