INFUL_PFBEXL_VW (SQL View)	Index Back
Ext Ref ID Line View 08/04/04 PWF Data Model Change: Change to IN_DEMAND to SHIP_INF_INV

INFUL_PFBEXL_VW

(SQL View)

Ext Ref ID Line View

08/04/04 PWF Data Model Change: Change to IN_DEMAND to SHIP_INF_INV

SELECT DISTINCT business_unit , DEMAND_SOURCE , SOURCE_BUS_UNIT , EXT_REF_NBR , EXT_REF_LN_NBR FROM PS_IN_DEMAND WHERE EXT_REF_LN_NBR <> 0 AND IN_FULFILL_STATE ='40' AND CONFIRMED_FLAG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 SL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand

3 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection

4 SL_EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number selection

5 SL_EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line selection

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
2	SL_DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source selection IN=Material Request OM=Sales Order PL=Planning Requisition PO=Sourced Demand PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order Demand
3	SL_SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Business Unit selection
4	SL_EXT_REF_NBR	Number(10,0)	DECIMAL(10) NOT NULL	External Reference Number selection
5	SL_EXT_REF_LN_NBR	Number(5,0)	INTEGER NOT NULL	External Reference Line selection