Search Results proposal_status_code

Overview

APPS.PRP_PROP_CUSTOMERS_V is a valid, internal Oracle E-Business Suite view owned by the APPS schema in the Oracle Trade Management (ETRM) module. It belongs to the PRP (Proposals) product family and is registered in FND Design Data as PRP.PRP_PROP_CUSTOMERS_V. The view presents a consolidated, customer-facing projection of proposal records, combining proposal header data with customer and resource information and content-item version attributes. Because it is documented with an "Oracle Internal Use Only" warning, Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs, and it should be treated as a reporting surface rather than a supported integration interface.

In practice, the view is used by Oracle's Proposal and Trade Management functionality to display proposals in conjunction with the owning resource, the associated customer party, and the current content version. It appears in 12.1.1 and 12.2.2 with an identical documented structure. Note that the view is not referenced by any other database object, so it functions as a leaf-level read construct.

Underlying Base Objects

The view is defined over a combination of base tables and supporting objects. The documented dependencies are:

PRP_PROPOSALS — the primary proposal header table supplying PROPOSAL_ID, PROPOSAL_NAME, PROPOSAL_DESC, PROPOSAL_STATUS_CODE, and DUE_DATE.
PRP_PROPOSAL_ACCESSES — supplies the owner and party relationship, including OWNER_USER_ID and CONTACT_PARTY_ID, used to restrict proposals to the appropriate customer or resource.
PRP_PROPOSAL_CTNTVERS — the proposal content version table supplying CITEM_VERSION_ID and related content metadata.
PRP_PROP_CTNTVER_FORMATS — supplies file and format details such as FILE_ID and FILE_FORMAT.
FND_LOOKUP_VALUES — the lookup synonym used to translate PROPOSAL_STATUS_CODE into the descriptive PROPOSAL_STATUS value.
JTF_RS_RESOURCE_EXTNS_VL — the resource extended view supplying OWNER_NAME.
FND_GLOBAL — the standard Oracle Applications package version used to derive runtime context, such as the current user and responsibility.

Because base tables are referenced through synonyms in the APPS schema, the view presents a denormalized, secured representation of proposal activity across the ETRM proposal and resource model.

Key Columns

PROPOSAL_ID — unique identifier of the proposal record; the primary join key to PRP_PROPOSALS.
OWNER_USER_ID / OWNER_NAME — the internal user identifier and resolved display name of the proposal owner, sourced through JTF_RS_RESOURCE_EXTNS_VL.
PARTY_ID / CONTACT_PARTY_ID — customer party and the specific contact party associated with the proposal access record.
PROPOSAL_NAME / PROPOSAL_DESC — descriptive attributes of the proposal (up to 240 and 2000 characters respectively).
PROPOSAL_STATUS_CODE — the coded status value (30-char VARCHAR2) stored on the proposal header; the target of the user's search.
PROPOSAL_STATUS — the decoded, user-visible status description (80-char VARCHAR2) obtained via FND_LOOKUP_VALUES for the proposal status lookup type.
DUE_DATE — the effective due date of the proposal.
UPDATE_FLAG — indicator of the update state of the record.
FILE_ID / FILE_FORMAT — reference to the associated content file and its format.
CITEM_VERSION_ID / CONTENT_ITEM_ID — content item and version identifiers linking the proposal to its stored version.
PROPOSAL_LANGUAGE — the language associated with the proposal content.

Common Use Cases and Queries

The view is typically used for reporting on open and in-progress proposals by status, owner, or customer. A frequent pattern filters on PROPOSAL_STATUS_CODE when the coded value is known, or on PROPOSAL_STATUS for display-oriented reports. Restricting by due date supports aging and forecast reporting.

A representative query resolves proposals by status for a specific customer party:

SELECT proposal_id,
       proposal_name,
       owner_name,
       proposal_status_code,
       proposal_status,
       due_date
FROM   apps.prp_prop_customers_v
WHERE  party_id = :p_party_id
AND    proposal_status_code = :p_status_code
ORDER  BY due_date;

A second scenario reports active proposals grouped by status description, useful for dashboards or workflow queues:

SELECT proposal_status,
       COUNT(*) AS proposal_count
FROM   apps.prp_prop_customers_v
WHERE  proposal_status_code NOT IN ('CLOSED','CANCELLED')
GROUP  BY proposal_status
ORDER  BY proposal_status;

Because the object carries the Oracle internal-use restriction, consumers should limit usage to supported Applications programs, avoid DML, and rely on standard proposal and customer APIs for any integration requirement. Joining back to PRP_PROPOSALS on PROPOSAL_ID should be reserved for documented, read-only reporting where no supported public view is available.

VIEW: APPS.PRP_PROP_CUSTOMERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_CUSTOMERS_V, object_name:PRP_PROP_CUSTOMERS_V, status:VALID,
VIEW: APPS.PRP_PROP_OBJECTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_OBJECTS_V, object_name:PRP_PROP_OBJECTS_V, status:VALID,
VIEW: APPS.PRP_PROP_OBJECTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_OBJECTS_V, object_name:PRP_PROP_OBJECTS_V, status:VALID,
VIEW: APPS.PRP_PROP_CUSTOMERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_CUSTOMERS_V, object_name:PRP_PROP_CUSTOMERS_V, status:VALID,
View: PRP_PROP_CUSTOMERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_CUSTOMERS_V, object_name:PRP_PROP_CUSTOMERS_V, status:VALID, product: PRP - Proposals , description: This View Provides proposal and proposal version details. , implementation_dba_data: APPS.PRP_PROP_CUSTOMERS_V ,
View: PRP_PROP_OBJECTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_OBJECTS_V, object_name:PRP_PROP_OBJECTS_V, status:VALID, product: PRP - Proposals , description: This View Provides proposal and proposal objects details. , implementation_dba_data: APPS.PRP_PROP_OBJECTS_V ,
View: PRP_PROP_OBJECTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_OBJECTS_V, object_name:PRP_PROP_OBJECTS_V, status:VALID, product: PRP - Proposals , description: This View Provides proposal and proposal objects details. , implementation_dba_data: APPS.PRP_PROP_OBJECTS_V ,
View: PRP_PROP_CUSTOMERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PRP.PRP_PROP_CUSTOMERS_V, object_name:PRP_PROP_CUSTOMERS_V, status:VALID, product: PRP - Proposals , description: This View Provides proposal and proposal version details. , implementation_dba_data: APPS.PRP_PROP_CUSTOMERS_V ,
PACKAGE BODY: APPS.IGW_UTILS 12.1.1
eTRM - PRP Tables and Views 12.1.1
description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. ,
eTRM - PRP Tables and Views 12.2.2
description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. ,