Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - PJM Tables and Views

TABLE - PJM.PJM_BORROW_PAYBACKS

TABLE - PJM.PJM_BORROW_TRANSACTIONS

TABLE - PJM.PJM_DEFAULT_TASKS

TABLE - PJM.PJM_MASS_TRANSFERS

TABLE - PJM.PJM_MASS_TRANSFER_TASKS

TABLE - PJM.PJM_ORG_PARAMETERS

TABLE - PJM.PJM_PROJECT_PARAMETERS

TABLE - PJM.PJM_SEIBAN_NUMBERS

TABLE - PJM.PJM_TASK_ATTRIBUTES_TL

TABLE - PJM.PJM_TASK_ATTR_USAGES_B

TABLE - PJM.PJM_TASK_ATTR_USAGES_TL

TABLE - PJM.PJM_TASK_WIP_ACCT_CLASSES

TABLE - PJM.PJM_UNIT_NUMBERS

TABLE - PJM.PJM_UNIT_SERIAL_HISTORY

VIEW - APPS.PJMBV_ITEM_MODEL_UNIT_NUMS

VIEW - APPS.PJMBV_PROJECT_MFG_INFORMATION

VIEW - APPS.PJMBV_PROJECT_MFG_ORGS

VIEW - APPS.PJMBV_PROJECT_MFG_PROJECTS

VIEW - APPS.PJMBV_SEIBAN_NUMBERS

VIEW - APPS.PJMFV_ITEM_MODEL_UNIT_NUMS

VIEW - APPS.PJMFV_PROJECT_MFG_INFORMATION

VIEW - APPS.PJMFV_PROJECT_MFG_ORGS

VIEW - APPS.PJMFV_PROJECT_MFG_PROJECTS

VIEW - APPS.PJMFV_SEIBAN_NUMBERS

VIEW - APPS.PJM_BORROW_PAYBACK_DETAIL_V

VIEW - APPS.PJM_BORROW_PAYBACK_SUMMARY_V

VIEW - APPS.PJM_DEFAULT_TASKS_INV_V

VIEW - APPS.PJM_DEFAULT_TASKS_SCP_V

VIEW - APPS.PJM_DEFAULT_TASKS_WIPL_V

VIEW - APPS.PJM_DEFAULT_TASKS_WIPM_V

VIEW - APPS.PJM_LINE_SCHEDULES_V

VIEW - APPS.PJM_ORG_PARAMETERS_V

VIEW - APPS.PJM_ORG_PROJECTS_V

VIEW - APPS.PJM_PO_COMMITMENTS_BASIC_V

VIEW - APPS.PJM_PO_COMMITMENTS_CMPRJ_V

VIEW - APPS.PJM_PO_COMMITMENTS_STUB_V

VIEW - APPS.PJM_PROJECTS_ALL_OU_V

VIEW - APPS.PJM_PROJECTS_ALL_V

VIEW - APPS.PJM_PROJECTS_MTLL_PSV

VIEW - APPS.PJM_PROJECTS_MTLL_PV

VIEW - APPS.PJM_PROJECTS_MTLL_SV

VIEW - APPS.PJM_PROJECTS_MTLL_V

VIEW - APPS.PJM_PROJECTS_ORG_OU_V

VIEW - APPS.PJM_PROJECTS_ORG_V

VIEW - APPS.PJM_PROJECTS_V

VIEW - APPS.PJM_PROJECT_BLANKET_PO_V

VIEW - APPS.PJM_PROJECT_COMMIT_V

VIEW - APPS.PJM_PROJECT_COST_HISTORY_V

VIEW - APPS.PJM_PROJECT_EXPEND_V

VIEW - APPS.PJM_PROJECT_MFG_PLAN_V

VIEW - APPS.PJM_PROJECT_OE_DEMAND_V

VIEW - APPS.PJM_PROJECT_OM_DEMAND_V

VIEW - APPS.PJM_PROJECT_ONHAND_V

VIEW - APPS.PJM_PROJECT_ONHAND_VALUE_V

VIEW - APPS.PJM_PROJECT_PARAMETERS_V

VIEW - APPS.PJM_PROJECT_PO_V

VIEW - APPS.PJM_PROJECT_PROJ_BASIC_V

VIEW - APPS.PJM_PROJECT_PROJ_LS_DAILY_V

VIEW - APPS.PJM_PROJECT_PROJ_LS_DETAIL_V

VIEW - APPS.PJM_PROJECT_PROJ_LS_ITEM_SUM_V

VIEW - APPS.PJM_PROJECT_PROJ_LS_LINE_SUM_V

VIEW - APPS.PJM_PROJECT_PROJ_LS_WEEKLY_V

VIEW - APPS.PJM_PROJECT_PROJ_SUMMARY_V

VIEW - APPS.PJM_PROJECT_PROJ_V

VIEW - APPS.PJM_PROJECT_QUOT_V

VIEW - APPS.PJM_PROJECT_REQ_V

VIEW - APPS.PJM_PROJECT_RFQ_V

VIEW - APPS.PJM_PROJECT_SEIBAN_V

VIEW - APPS.PJM_PROJECT_SO_V

VIEW - APPS.PJM_PROJECT_TASK_BASIC_V

VIEW - APPS.PJM_PROJECT_TASK_LS_DAILY_V

VIEW - APPS.PJM_PROJECT_TASK_LS_ITEM_SUM_V

VIEW - APPS.PJM_PROJECT_TASK_LS_LINE_SUM_V

VIEW - APPS.PJM_PROJECT_TASK_LS_WEEKLY_V

VIEW - APPS.PJM_PROJECT_TASK_V

VIEW - APPS.PJM_PROJECT_WIP_COMP_V

VIEW - APPS.PJM_PROJECT_WIP_OP_V

VIEW - APPS.PJM_PROJECT_WIP_V

VIEW - APPS.PJM_REQ_COMMITMENTS_BASIC_V

VIEW - APPS.PJM_REQ_COMMITMENTS_CMPRJ_V

VIEW - APPS.PJM_REQ_COMMITMENTS_STUB_V

VIEW - APPS.PJM_SEIBAN_NUMBERS_V

VIEW - APPS.PJM_TASKS_MTLL_V

VIEW - APPS.PJM_TASKS_MXFR_V

VIEW - APPS.PJM_TASKS_V

VIEW - APPS.PJM_TASK_ATTRIBUTES

VIEW - APPS.PJM_TASK_ATTR_USAGES

VIEW - APPS.PJM_TASK_ATTR_USAGES_V

VIEW - APPS.PJM_TASK_RULES_ORG_V

VIEW - APPS.PJM_TASK_RULES_PROJECTS_V

VIEW - APPS.PJM_TASK_WIP_ACCT_CLASSES_V

VIEW - APPS.PJM_UEFF_END_ITEMS_V

VIEW - APPS.PJM_UEFF_SO_LINES_V

VIEW - APPS.PJM_UNIT_NUMBERS_LOV_V

Table: PJM_BORROW_PAYBACKS

Primary Key: PJM_BORROW_PAYBACKS_PK

1. PAYBACK_TRANSACTION_ID
2. BORROW_TRANSACTION_ID

Foreign Keys from this table:

Comments

PJM_BORROW_PAYBACKS captures allocation of inter-project payback transactions to outstanding borrow transactions. Information stored in this table is used by the Cost Processor to determine proper accounting entries for the payback transaction. Payback quantity is allocated to borrow transactions using a FIFO algorithm.

Indexes

Columns

[top of page]

PJM.PJM_BORROW_PAYBACKS does not reference any database object

PJM.PJM_BORROW_PAYBACKS is referenced by following:

PJM

VIEW - PJM_BORROW_PAYBACKS#

[top of page]

Table: PJM_BORROW_TRANSACTIONS

Primary Key: PJM_BORROW_TRANSACTIONS_PK

1. BORROW_TRANSACTION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

PJM_BORROW_TRANSACTIONS captures borrow transactions as they were entered into MTL_MATERIAL_TRANSACTIONS. In addition, this table maintains the outstanding loan quantity for each borrow transaction. One borrow transaction can be paid back by many payback transactions.

Indexes

Columns

[top of page]

PJM.PJM_BORROW_TRANSACTIONS does not reference any database object

PJM.PJM_BORROW_TRANSACTIONS is referenced by following:

PJM

VIEW - PJM_BORROW_TRANSACTIONS#

[top of page]

Table: PJM_DEFAULT_TASKS

Foreign Keys from this table:

Comments

PJM_DEFAULT_TASKS stores Task AutoAssignment rules. The rules are maintained through the Task AutoAssignment Rules form and are interpreted by the Task AutoAssignment engine during Cost Collection process, Commitments capture and Invoices Charges transfer.
This table corresponds to the Task AutoAssignment Rules window.

Indexes

Columns

[top of page]

PJM.PJM_DEFAULT_TASKS does not reference any database object

PJM.PJM_DEFAULT_TASKS is referenced by following:

PJM

VIEW - PJM_DEFAULT_TASKS#

[top of page]

Table: PJM_MASS_TRANSFERS

Primary Key: PJM_MASS_TRANSFERS_PK

1. MASS_TRANSFER_ID

Foreign Keys to this table:

Comments

PJM_MASS_TRANSFERS stores details about project mass transfer requests. This table is used during the approval process as well as the actual processing / generation of the transfer transactions.

Indexes

Columns

[top of page]

PJM.PJM_MASS_TRANSFERS does not reference any database object

PJM.PJM_MASS_TRANSFERS is referenced by following:

PJM

VIEW - PJM_MASS_TRANSFERS#

[top of page]

Table: PJM_MASS_TRANSFER_TASKS

Foreign Keys from this table:

Comments

PJM_MASS_TRANSFERS stores specific tasks where transfer should occur for each project mass transfer request.

Indexes

Columns

[top of page]

PJM.PJM_MASS_TRANSFER_TASKS does not reference any database object

PJM.PJM_MASS_TRANSFER_TASKS is referenced by following:

PJM

VIEW - PJM_MASS_TRANSFER_TASKS#

[top of page]

Table: PJM_ORG_PARAMETERS

Primary Key: PJM_ORG_PARAMETERS_PK

1. ORGANIZATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

PJM_ORG_PARAMETERS stores inventory organization level information used to control Oracle Project Manufacturing. Each row represents the settings for an entire inventory organization and contains project control level and other transaction controls, various default expenditure types, common project, and default general ledger accounts for borrow/payback variances.
This table corresponds to the PJM Organization Parameters window.

Indexes

Columns

[top of page]

PJM.PJM_ORG_PARAMETERS does not reference any database object

PJM.PJM_ORG_PARAMETERS is referenced by following:

PJM

VIEW - PJM_ORG_PARAMETERS#

[top of page]

Table: PJM_PROJECT_PARAMETERS

Primary Key: PJM_PROJECT_PARAMETERS_PK

1. PROJECT_ID
2. ORGANIZATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

PJM_PROJECT_PARAMETERS stores the Project Manufacturing parameters
for a given project and inventory organization.
This table corresponds to the Project Parameters window.

Indexes

Columns

[top of page]

PJM.PJM_PROJECT_PARAMETERS does not reference any database object

PJM.PJM_PROJECT_PARAMETERS is referenced by following:

PJM

VIEW - PJM_PROJECT_PARAMETERS#

[top of page]

Table: PJM_SEIBAN_NUMBERS

Primary Key: PJM_SEIBAN_NUMBERS_PK

1. PROJECT_ID

Foreign Keys to this table:

Comments

PJM_SEIBAN_NUMBERS stores Seiban numbers.
This table corresponds to the Seiban Number window of the Seiban Number Wizard form.

Indexes

Columns

[top of page]

PJM.PJM_SEIBAN_NUMBERS does not reference any database object

PJM.PJM_SEIBAN_NUMBERS is referenced by following:

PJM

VIEW - PJM_SEIBAN_NUMBERS#

[top of page]

Table: PJM_TASK_ATTRIBUTES_TL

Primary Key: PJM_TASK_ATTRIBUTES_TL_PK

1. ASSIGNMENT_TYPE
2. ATTRIBUTE_CODE
3. LANGUAGE

Comments

PJM_TASK_ATTRIBUTES stores available Task AutoAssignment attributes for each assignment type. At this time, the list of attributes is static and is not user-extensible.

Indexes

Columns

[top of page]

PJM.PJM_TASK_ATTRIBUTES_TL does not reference any database object

PJM.PJM_TASK_ATTRIBUTES_TL is referenced by following:

PJM

VIEW - PJM_TASK_ATTRIBUTES_TL#

[top of page]

Table: PJM_TASK_ATTR_USAGES_B

Primary Key: PJM_TASK_ATTR_USAGES_UK01

1. ASSIGNMENT_TYPE
2. SEQUENCE_NUMBER

Comments

PJM_TASK_ATTR_USAGES stores the Task AutoAssignment attribute usage and sequencing definition for each assignment type. The usage and sequencing information is used in the Task AutoAssignment Rules form for dynamic painting of the attributes as well as the Task AutoAssignment engine.
This table corresponds to the Task AutoAssign FlexSequence window.

Indexes

Columns

[top of page]

PJM.PJM_TASK_ATTR_USAGES_B does not reference any database object

PJM.PJM_TASK_ATTR_USAGES_B is referenced by following:

PJM

VIEW - PJM_TASK_ATTR_USAGES_B#

[top of page]

Table: PJM_TASK_ATTR_USAGES_TL

Primary Key: PJM_TASK_ATTR_USAGES_TK_UK1

1. ASSIGNMENT_TYPE
2. PROMPT
3. LANGUAGE

Primary Key: PJM_TASK_ATTR_USAGES_TL_PK

1. ASSIGNMENT_TYPE
2. ATTRIBUTE_CODE
3. LANGUAGE

Comments

PJM_TASK_ATTR_USAGES stores language specific information on the Task AutoAssignment attribute usage and sequencing definition.

Indexes

Columns

[top of page]

PJM.PJM_TASK_ATTR_USAGES_TL does not reference any database object

PJM.PJM_TASK_ATTR_USAGES_TL is referenced by following:

PJM

VIEW - PJM_TASK_ATTR_USAGES_TL#

[top of page]

Table: PJM_TASK_WIP_ACCT_CLASSES

Primary Key: PJM_TASK_WIP_ACCT_CLASSES_PK

1. PROJECT_ID
2. ORGANIZATION_ID
3. TASK_ID

Foreign Keys from this table:

Comments

PJM_TASK_WIP_ACCT_CLASSES stores default standard discrete and maintenance WIP accounting classes for a task in each organization.

Indexes

Columns

[top of page]

PJM.PJM_TASK_WIP_ACCT_CLASSES does not reference any database object

PJM.PJM_TASK_WIP_ACCT_CLASSES is referenced by following:

PJM

VIEW - PJM_TASK_WIP_ACCT_CLASSES#

[top of page]

Table: PJM_UNIT_NUMBERS

Primary Key: PJM_UNIT_NUMBERS_PK

1. UNIT_NUMBER

Foreign Keys from this table:

Foreign Keys to this table:

Comments

PJM_UNIT_NUMBERS holds unique End Item Model/Unit Numbers for model/unit number effectivity controlled end items. The End Item Model/Unit Number is an alphanumeric string that typically includes a prefix and a number in sequence; for example, FAN-0001. The unit numbers defined for end items must be unique across organizations and across items.
This table corresponds to the Maintain Model/Unit Numbers window.

Indexes

Columns

[top of page]

PJM.PJM_UNIT_NUMBERS does not reference any database object

PJM.PJM_UNIT_NUMBERS is referenced by following:

PJM

VIEW - PJM_UNIT_NUMBERS#

[top of page]

Table: PJM_UNIT_SERIAL_HISTORY

Primary Key: PJM_UNIT_SERIAL_HISTORY_PK

1. INVENTORY_ITEM_ID
2. SERIAL_NUMBER
3. OLD_UNIT_NUMBER
4. NEW_UNIT_NUMBER

Foreign Keys from this table:

Comments

PJM_UNIT_SERIAL_HISTORY holds unit number change history made to any serialized on hand to provide audit trail. This table is populated by a trigger on MTL_SERIAL_NUMBERS.

Indexes

Columns

[top of page]

PJM.PJM_UNIT_SERIAL_HISTORY does not reference any database object

PJM.PJM_UNIT_SERIAL_HISTORY is referenced by following:

PJM

VIEW - PJM_UNIT_SERIAL_HISTORY#

[top of page]

View: PJMBV_ITEM_MODEL_UNIT_NUMS

Comments

View Type

A Business Intelligence System view

This shows end item model/unit numbers that identifies a specific configuration in the Bills of Material of an assembly.

Columns

[top of page]

APPS

SYNONYM - PJM_UNIT_NUMBERS

APPS.PJMBV_ITEM_MODEL_UNIT_NUMS is not referenced by any database object

[top of page]

View: PJMBV_PROJECT_MFG_INFORMATION

Comments

View Type

A Business Intelligence System view

This shows the operating parameters for a manufacturing project in an inventory organization, including planning group, cost group, WIP accounting class, etc.

Columns

[top of page]

APPS

PACKAGE - HR_GENERAL

VIEW - HR_ORGANIZATION_UNITS

PACKAGE - HR_SECURITY

SYNONYM - MTL_PARAMETERS

VIEW - PJMBV_PROJECT_MFG_PROJECTS

SYNONYM - PJM_PROJECT_PARAMETERS

APPS.PJMBV_PROJECT_MFG_INFORMATION is not referenced by any database object

[top of page]

View: PJMBV_PROJECT_MFG_ORGS

Comments

View Type

A Business Intelligence System view

Columns

[top of page]

APPS

SYNONYM - PJM_ORG_PARAMETERS

APPS.PJMBV_PROJECT_MFG_ORGS is not referenced by any database object

[top of page]

View: PJMBV_PROJECT_MFG_PROJECTS

Comments

View Type

A Business Intelligence System view

This combines PA projects and Seiban numbers to provide a centralized reference for Manufacturing entities.

Columns

[top of page]

APPS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PJM_SEIBAN_NUMBERS

APPS

VIEW - PJMBV_PROJECT_MFG_INFORMATION

VIEW - PJMFV_PROJECT_MFG_INFORMATION

[top of page]

View: PJMBV_SEIBAN_NUMBERS

Comments

View Type

A Business Intelligence System view

This shows all Seiban numbers.

Columns

[top of page]

APPS

SYNONYM - PJM_SEIBAN_NUMBERS

APPS.PJMBV_SEIBAN_NUMBERS is not referenced by any database object

[top of page]

View: PJMFV_ITEM_MODEL_UNIT_NUMS

Comments

View Type

A Business Intelligence System view

This shows end item model/unit numbers that identifies a specific configuration in the Bills of Material of an assembly.

Columns

[top of page]

APPS

SYNONYM - HR_ALL_ORGANIZATION_UNITS

SYNONYM - MTL_PARAMETERS

SYNONYM - MTL_SYSTEM_ITEMS

SYNONYM - PJM_UNIT_NUMBERS

APPS.PJMFV_ITEM_MODEL_UNIT_NUMS is not referenced by any database object

[top of page]

View: PJMFV_PROJECT_MFG_INFORMATION

Comments

View Type

A Business Intelligence System view

This shows the operating parameters for a manufacturing project in an inventory organization, including planning group, cost group, WIP accounting class, etc.

Columns

[top of page]

APPS

SYNONYM - CST_COST_GROUPS

PACKAGE - HR_GENERAL

VIEW - HR_ORGANIZATION_UNITS

PACKAGE - HR_SECURITY

SYNONYM - MTL_PARAMETERS

VIEW - PJMBV_PROJECT_MFG_PROJECTS

SYNONYM - PJM_PROJECT_PARAMETERS

APPS.PJMFV_PROJECT_MFG_INFORMATION is not referenced by any database object

[top of page]

View: PJMFV_PROJECT_MFG_ORGS

Comments

View Type

A Business Intelligence System view

Columns

[top of page]

APPS

SYNONYM - GL_CODE_COMBINATIONS

SYNONYM - HR_ALL_ORGANIZATION_UNITS

SYNONYM - MTL_PARAMETERS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PJM_ORG_PARAMETERS

APPS.PJMFV_PROJECT_MFG_ORGS is not referenced by any database object

[top of page]

View: PJMFV_PROJECT_MFG_PROJECTS

Comments

View Type

A Business Intelligence System view

This combines PA projects and Seiban numbers to provide a centralized reference for Manufacturing entities.

Columns

[top of page]

APPS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PJM_SEIBAN_NUMBERS

APPS

VIEW - WIPFV_FLOW_SCHEDULES

VIEW - WIPFV_MFG_RESOURCE_TXNS

VIEW - WIPFV_MFG_TRANSACTIONS

VIEW - WIPFV_OSP_MFG_TXNS

VIEW - WIPFV_OVERHEAD_MFG_TXNS

VIEW - WIPFV_WIP_JOBS

[top of page]

View: PJMFV_SEIBAN_NUMBERS

Comments

View Type

A Business Intelligence System view

This shows all Seiban numbers.

Columns

[top of page]

APPS

SYNONYM - PJM_SEIBAN_NUMBERS

APPS.PJMFV_SEIBAN_NUMBERS is not referenced by any database object

[top of page]

View: PJM_BORROW_PAYBACK_DETAIL_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - MTL_MATERIAL_TRANSACTIONS

SYNONYM - MTL_TRANSACTION_TYPES

SYNONYM - PJM_BORROW_PAYBACKS

SYNONYM - PJM_BORROW_TRANSACTIONS

APPS.PJM_BORROW_PAYBACK_DETAIL_V is not referenced by any database object

[top of page]

View: PJM_BORROW_PAYBACK_SUMMARY_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - CST_COST_GROUPS

PACKAGE - PJM_BORROW_PAYBACK

SYNONYM - PJM_BORROW_TRANSACTIONS

PACKAGE - PJM_PROJECT

SYNONYM - PJM_PROJECT_PARAMETERS

APPS.PJM_BORROW_PAYBACK_SUMMARY_V is not referenced by any database object

[top of page]

View: PJM_DEFAULT_TASKS_INV_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

PACKAGE - HR_GENERAL

VIEW - HR_ORGANIZATION_UNITS

PACKAGE - HR_SECURITY

SYNONYM - MTL_PARAMETERS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PA_TASKS

SYNONYM - PJM_DEFAULT_TASKS

SYNONYM - PO_HEADERS_ALL

APPS.PJM_DEFAULT_TASKS_INV_V is not referenced by any database object

[top of page]

View: PJM_DEFAULT_TASKS_SCP_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

PACKAGE - HR_GENERAL

VIEW - HR_ORGANIZATION_UNITS

PACKAGE - HR_SECURITY

SYNONYM - MTL_PARAMETERS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PA_TASKS

SYNONYM - PJM_DEFAULT_TASKS

APPS.PJM_DEFAULT_TASKS_SCP_V is not referenced by any database object

[top of page]

View: PJM_DEFAULT_TASKS_WIPL_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_STANDARD_OPERATIONS

PACKAGE - HR_GENERAL

VIEW - HR_ORGANIZATION_UNITS

PACKAGE - HR_SECURITY

SYNONYM - MTL_PARAMETERS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PA_TASKS

SYNONYM - PJM_DEFAULT_TASKS

APPS.PJM_DEFAULT_TASKS_WIPL_V is not referenced by any database object

[top of page]

View: PJM_DEFAULT_TASKS_WIPM_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_STANDARD_OPERATIONS

PACKAGE - HR_GENERAL

VIEW - HR_ORGANIZATION_UNITS

PACKAGE - HR_SECURITY

SYNONYM - MTL_PARAMETERS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PA_TASKS

SYNONYM - PJM_DEFAULT_TASKS

APPS.PJM_DEFAULT_TASKS_WIPM_V is not referenced by any database object

[top of page]

View: PJM_LINE_SCHEDULES_V

Comments

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

PJM_LINE_SCHEDULES_V is a lower level view that returns line scheduling detail information. While not directly used in the Web Inquiry, this view provides different levels of summarization by item, day or week for a project or task.

Columns

[top of page]

APPS

VIEW - MFG_LOOKUPS

SYNONYM - MTL_SYSTEM_ITEMS_KFV

SYNONYM - WIP_DISCRETE_JOBS

SYNONYM - WIP_ENTITIES

SYNONYM - WIP_FLOW_SCHEDULES

SYNONYM - WIP_LINES

APPS

VIEW - PJM_PROJECT_PROJ_LS_DAILY_V

VIEW - PJM_PROJECT_PROJ_LS_DETAIL_V

VIEW - PJM_PROJECT_PROJ_LS_ITEM_SUM_V

VIEW - PJM_PROJECT_PROJ_LS_LINE_SUM_V

VIEW - PJM_PROJECT_PROJ_LS_WEEKLY_V

VIEW - PJM_PROJECT_TASK_LS_DAILY_V

VIEW - PJM_PROJECT_TASK_LS_ITEM_SUM_V

VIEW - PJM_PROJECT_TASK_LS_LINE_SUM_V

VIEW - PJM_PROJECT_TASK_LS_WEEKLY_V

[top of page]

View: PJM_ORG_PARAMETERS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PJM_ORG_PARAMETERS

APPS.PJM_ORG_PARAMETERS_V is not referenced by any database object

[top of page]

View: PJM_ORG_PROJECTS_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

PJM_ORG_PROJECTS_V returns all chargeable projects and seiban numbers
for which Project Manufacturing parameters have been defined.

Columns

[top of page]

APPS

PACKAGE - FND_PROFILE

PACKAGE - MRP_GET_PROJECT

PACKAGE - PA_CROSS_BUSINESS_GRP

PACKAGE - PA_PROJECT_UTILS

PACKAGE - PA_SECURITY

VIEW - PJM_PROJECTS_V

SYNONYM - PJM_PROJECT_PARAMETERS

APPS

VIEW - MTL_PROJECT_V

[top of page]

View: PJM_PO_COMMITMENTS_BASIC_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

PJM_PO_COMMITMENTS_BASIC_V returns project-related purchase order distributions in Oracle Purchasing which have a destination of Inventory or Shop Floor and have not yet been received.
This view is similar to PJM_PO_COMMITMENTS_CMPRJ_V, but has been simplified by removing common project logic for better performance.

Columns

[top of page]

APPS

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

SYNONYM - PA_EXPENDITURE_TYPES

SYNONYM - PA_PROJECTS_ALL

SYNONYM - PA_TASKS

PACKAGE - PJM_COMMITMENT_UTILS

SYNONYM - PO_DISTRIBUTIONS_ALL

SYNONYM - PO_HEADERS_ALL

SYNONYM - PO_LINES_ALL

SYNONYM - PO_LINE_LOCATIONS_ALL

SYNONYM - PO_RELEASES_ALL

- GL_SETS_OF_BOOKS

APPS.PJM_PO_COMMITMENTS_BASIC_V is not referenced by any database object

[top of page]

View: PJM_PO_COMMITMENTS_CMPRJ_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

PJM_PO_COMMITMENTS_CMPRJ_V returns project-related purchase order distributions in Oracle Purchasing which have a destination of Inventory or Shop Floor and have not yet been received.
Most of the project information required by Oracle Projects are derived using the following algorithm:
- If a project is directly referenced on the purchase order distribution, it will be used; otherwise, if the destination organization is associated with a common project in the Project Manufacturing organization setup, the common project will be used.
- If Task AutoAssignment is implemented, task is derived from the predefined assignment rules if a task is not directly referenced on the purchase order distribution.
- Expenditure item date is derived from the first available value need-by date, promised date and creation date of the shipment line, in that order.
- The destination organization is used as the expenditure organization if the destination is inventory, otherwise the expenditure organization will be derived from the BOM department of the receiving routing operation if the destination is shop floor.
- Expenditure type is derived from the expenditure type associated with the first material sub-element of the item.
.
Because of differences in Task AutoAssignment attributes, this view is split into two UNION sections, one part for inventory destination purchase order distributions and the other part for shop floor destination purchase order distributions.
.
This view is used by the Oracle Projects Commitments module.

Columns