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

VIEW: APPS.PO_CLMREQ_DIST_DETAILS_V

Object Details
Object Name: PO_CLMREQ_DIST_DETAILS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Yes Requisition header unique identifier
REQUISITION_NUMBER VARCHAR2 (20) Yes Line number
REQUISITION_LINE_ID NUMBER
Yes Requisition line unique identifier
LINE_NUMBER VARCHAR2 (100)
Line number
AT_SOURCING_FLAG VARCHAR2 (1)
Whether or not this requisition line is part of an active sourcing negotiation. If 'Y', the req line is part of an active negotiation in Oracle Sourcing. If 'N' or 'NULL', the requisition line is not part of an active negotation in Oracle Sourcing.
REQS_IN_POOL_FLAG VARCHAR2 (1)
Flag to indicate if the requisitions are available for PO creation
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
PO_LINE_ID NUMBER

po_Line_id in the modification
AUCTION_HEADER_ID NUMBER

Reference to sourcing auction id
AUCTION_LINE_NUMBER NUMBER

reference to sourcing auction line number
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination subinventory name
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly identifier
WIP_LINE_ID NUMBER

WIP line identifier
WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule identifier
WIP_OPERATION_SEQ_NUM NUMBER

WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM NUMBER

WIP resource sequence number
BOM_RESOURCE_ID NUMBER

BOM resource unique identifier
DESTINATION_CONTEXT VARCHAR2 (30)
Destination descriptive flexfield context column
DELIVER_TO_LOCATION_ID NUMBER

Deliver-to location unique identifier
DESTINATION_ORGANIZATION_ID NUMBER

Destination organization unique identifier
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit of measure
ITEM_ID NUMBER

Item unique identifier
JOB_ID NUMBER

Reference to the HR Job
CURRENCY_CODE VARCHAR2 (15)
Unique identifier for the currency
UNIT_PRICE NUMBER

Unit price in functional currency
ITEM_DESCRIPTION VARCHAR2 (240) Yes Item description
DISTRIBUTION_ID NUMBER
Yes Requisition distribution unique identifier
SET_OF_BOOKS_ID NUMBER
Yes Set of Books unique identifier
CODE_COMBINATION_ID NUMBER
Yes Unique identifier for the General Ledger charge account
REQ_LINE_QUANTITY NUMBER

Quantity for the distribution
ENCUMBERED_FLAG VARCHAR2 (1)
Indicates whether the distribution is encumbered or not
GL_ENCUMBERED_DATE DATE

Date the distribution was encumbered
GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
Period in which the distribution was encumbered
GL_CANCELLED_DATE DATE

Date the distribution was cancelled
FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (25)
Type of approval failure for the distribution
ENCUMBERED_AMOUNT NUMBER

Encumbered amount for distribution
BUDGET_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger budget account
ACCRUAL_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger accrual account
VARIANCE_ACCOUNT_ID NUMBER

Unique identifier for the General Ledger variance account
PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
Indicates whether the distribution requires encumbrance or not
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
PROJECT_ID NUMBER

Stores the requisition_line_id of the parent line for DOD structure
TASK_ID NUMBER

Project accounting task unique identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Project accounting expenditure type
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
Project accounting descriptive flexfield context column
EXPENDITURE_ORGANIZATION_ID NUMBER

Project accounting expenditure organization unique identifier
GL_CLOSED_DATE DATE

Date the distribution was final-closed
SOURCE_REQ_DISTRIBUTION_ID NUMBER

Distribution unique identifier that indicates whether the distribution is encumbered when it is cancelled
DISTRIBUTION_NUM NUMBER
Yes Distribution number
PROJECT_RELATED_FLAG VARCHAR2 (1)
Indicates whether the distribution is project related
EXPENDITURE_ITEM_DATE DATE

Project accounting expenditure item date
ORG_ID NUMBER

Organization identifier
ALLOCATION_TYPE VARCHAR2 (25)
Method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE NUMBER

Allocation split value
AWARD_ID NUMBER (15)
Award identifier
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Project Manufacturing end item unit number
RECOVERABLE_TAX NUMBER

Recoverable tax amount
NONRECOVERABLE_TAX NUMBER

Nonrecoverable tax amount
RECOVERY_RATE NUMBER

Percentage of tax that can be recovered
TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
Indicator of whether tax recovery should be used
OKE_CONTRACT_LINE_ID NUMBER

Stores the line id of a contract
OKE_CONTRACT_DELIVERABLE_ID NUMBER

Stores the deliverable id corresponding to the contract
REQ_LINE_AMOUNT NUMBER

Amount on the req line
REQ_LINE_CURRENCY_AMOUNT NUMBER

Foreign Currency Amount on the requisition distribution
REQ_AWARD_ID NUMBER (15)
Award ID corresponding to the award on the requisition distribution. References GMS_AWARDS_ALL.award_id.
EVENT_ID NUMBER

Keeps track of latest SLA event
CONFORMED_DIST_ID NUMBER

Populated only for Amendment records and stores the distribution_id of the parent distribution
AMENDMENT_TYPE VARCHAR2 (30)
Used for PR Amendment and shows the type of change. Possible values are ADDED, CHANGED, CANCELLED
AMENDMENT_STATUS VARCHAR2 (3)
Used for PR Amendment and stores the amendment status. Possible values are N - New, A - Accepted, R - Rejected, P - Pending
UDA_TEMPLATE_ID NUMBER

Uda Template Id
INFO_LINE_ID NUMBER

Stores the requisition_line_id of the parent line for DOD structure
AMOUNT_FUNDED NUMBER

Stores the total amount funded against this distribution
FUNDED_VALUE NUMBER

Stores the funded value
PARTIAL_FUNDED_FLAG VARCHAR2 (1)
States whether this line is partially funded or fully funded
QUANTITY_FUNDED NUMBER

Stores the total quantity funded against this distribution
CLM_MISC_LOA VARCHAR2 (200)
States whether this distribution belongs to the Line Of Accounting
CLM_DEFENCE_FUNDING VARCHAR2 (10)
State whether this distribution is for defence funding
CLM_FMS_CASE_NUMBER VARCHAR2 (240)
Case number for CLM FMS.
CLM_AGENCY_ACCT_IDENTIFIER VARCHAR2 (1000)
The Agency Account identifier.
CHANGE_IN_FUNDED_VALUE NUMBER

The change in the funded value.
UNENCUMBERED_AMOUNT NUMBER

Amount that is unencumbered.
FUNDS_USED NUMBER

Stores the total amount funded against this distribution
FUNDS_REMAINING NUMBER

Stores the funded value
IS_FUNDS_REMAINING CHAR (1)
States whether this line is partially funded or fully funded
FUNDS_LIQUIDATED NUMBER

Stores the funded value
Query Text

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


SELECT REQUISITION_HEADER_ID
,      REQUISITION_NUMBER
,      REQUISITION_LINE_ID
,      LINE_NUMBER
,      AT_SOURCING_FLAG
,      REQS_IN_POOL_FLAG
,      LINE_LOCATION_ID
,      PO_LINE_ID
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      DESTINATION_TYPE_CODE
,      DESTINATION_SUBINVENTORY
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      BOM_RESOURCE_ID
,      DESTINATION_CONTEXT
,      DELIVER_TO_LOCATION_ID
,      DESTINATION_ORGANIZATION_ID
,      UNIT_MEAS_LOOKUP_CODE
,      ITEM_ID
,      JOB_ID
,      CURRENCY_CODE
,      UNIT_PRICE
,      ITEM_DESCRIPTION
,      DISTRIBUTION_ID
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      REQ_LINE_QUANTITY
,      ENCUMBERED_FLAG
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GL_CANCELLED_DATE
,      FAILED_FUNDS_LOOKUP_CODE
,      ENCUMBERED_AMOUNT
,      BUDGET_ACCOUNT_ID
,      ACCRUAL_ACCOUNT_ID
,      VARIANCE_ACCOUNT_ID
,      PREVENT_ENCUMBRANCE_FLAG
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      PROJECT_ACCOUNTING_CONTEXT
,      EXPENDITURE_ORGANIZATION_ID
,      GL_CLOSED_DATE
,      SOURCE_REQ_DISTRIBUTION_ID
,      DISTRIBUTION_NUM
,      PROJECT_RELATED_FLAG
,      EXPENDITURE_ITEM_DATE
,      ORG_ID
,      ALLOCATION_TYPE
,      ALLOCATION_VALUE
,      AWARD_ID
,      END_ITEM_UNIT_NUMBER
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_DELIVERABLE_ID
,      REQ_LINE_AMOUNT
,      REQ_LINE_CURRENCY_AMOUNT
,      REQ_AWARD_ID
,      EVENT_ID
,      CONFORMED_DIST_ID
,      AMENDMENT_TYPE
,      AMENDMENT_STATUS
,      UDA_TEMPLATE_ID
,      INFO_LINE_ID
,      AMOUNT_FUNDED
,      FUNDED_VALUE
,      PARTIAL_FUNDED_FLAG
,      QUANTITY_FUNDED
,      CLM_MISC_LOA
,      CLM_DEFENCE_FUNDING
,      CLM_FMS_CASE_NUMBER
,      CLM_AGENCY_ACCT_IDENTIFIER
,      CHANGE_IN_FUNDED_VALUE
,      UNENCUMBERED_AMOUNT
,      FUNDS_USED
,      FUNDS_REMAINING
,      IS_FUNDS_REMAINING
,      FUNDS_LIQUIDATED
FROM APPS.PO_CLMREQ_DIST_DETAILS_V;

Dependencies

[top of page]

APPS.PO_CLMREQ_DIST_DETAILS_V references the following:

SchemaAPPS
ViewPO_CLMREQ_DIST_FUNDS_USED_V
ViewPO_REQUISITION_HEADERS_CLM_V
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
APPS.PO_CLMREQ_DIST_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyPO_AUTO_LINE_PROCESS_PVT - show dependent code
Package BodyPO_DOCUMENT_CHECKS_PVT - show dependent code
Package BodyPO_ENCUMBRANCE_PREPROCESSING - show dependent code
Package BodyPO_LINK_REQ_DIST_PVT - show dependent code
Package BodyPO_VAL_DISTRIBUTIONS - show dependent code