Common report parameter value sets

Common Report Parameter Value Sets

November 14, 2014 11:43:45 Cauliflower 1110 Views: 608 Tags: reports oracle More

Category: Report

(1)P_ORGNIZATION_ID：10/NUMBER

Configuration file: MFG_ORGANIZATION_ID

: INV_ORG_ID--Inventory Organization

Configuration file: MFG_ORGANIZATION_ID

(2)P_CREATION_DATE: GL_PERIODS--Accounting period, format "Y-MM"

=>SELECT GP.START_DATE,

GP.END_DATE

FROM GL_PERIODS GP --GL Period Table

WHERE GP.PERIOD_NAME = P_CREATION_DATE; --Time value set selected by parameter:GL_PERIODS Display "Y-MM"

(3)P_ITEM_CODE: INV_SRS_ITEM--Item Code

CUX_ITEM_SEGMENT--Item code as query criteria

(4)P_ASS_DESC: WIP_ITEM_DESCRIPTION--Item Description

(5)P_SUB_INV_NAME: P_SUB_INV_NAME--Subinventory Code

(6)P_PLENNER: CHV_SRS_PLANNER_ID--Planner Name/ID

(7)P_WIP_ENTITY_NAME: WIP_NAME--JOB NUMBER

(8)P_WIP_CLASS: WIP_SRS_CLASS_CODE_OPT--Job Order Type (All work-in-progress categories: 1-mass production, 8-prototype, 4-outsourcing...)

(9)P_WIP_STATUS: WIP_SRS_JOB_STATUS_DJVAL_OPT--Job Status (Job Status for Value Report: Completed, Not Completed...)

=>SELECT MEANING --CHINESE MEANING

from MFG_LOOKUPS--Status

WHERE LOOKUP_TYPE = 'WIP_JOB_STATUS'

AND LOOKUP_CODE IN (1,3,4,5,6,7,12,14,15)

ORDER BY LOOKUP_CODE --CODE

(10)P_DEPT_CODE: CUX_WIP_SCHEDULE_GROUP_NAME--Production Dept.

BOM_SRS_DEPARTMENT--Department List

(11)P_RELEASED_DATE: FND_STANDARD_DATE--Date

(12)P_LOT_NUMBER_FROM: INV_SRS_LOT_NUMBE--LOT

(13)P_FORECAST_DESIGNATOR: CUX_FORECAST_SETS--Prediction Set