RECV_INSPIST_VW

(SQL View)
 Index Back

Inspection Instructions view


SELECT h.shipto_id , i.business_unit , i.receiver_id , i.recv_ln_nbr , i.op_seq , i.routing_setid , i.routing_id , i.op_time_std , i.op_time_cd , i.op_time_std_ttl , i.op_time_act_ttl , i.process_instance , i.op_instructions FROM ps_recv_ln_insp i , PS_RECV_HDR h WHERE i.business_unit = h.business_unit AND i.receiver_id = h.receiver_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: RECV_LN_SHIP.BUSINESS_UNIT

3 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

Default Value: RECV_LN_SHIP.RECEIVER_ID

4 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
5 OP_SEQ Number(3,0) SMALLINT NOT NULL Op Seq
6 ROUTING_SETID Character(5) VARCHAR2(5) NOT NULL Routing SetID
7 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

Prompt Table: ROUTING_HDR

8 OP_TIME_STD Number(6,2) DECIMAL(5,2) NOT NULL Standard Operation Run Time
9 OP_TIME_CD Character(1) VARCHAR2(1) NOT NULL Operation Time Type
O=Per Batch
P=Per Unit

Default Value: P

10 OP_TIME_STD_TTL Number(16,2) DECIMAL(15,2) NOT NULL Operation Time Std Total
11 OP_TIME_ACT_TTL Number(16,2) DECIMAL(15,2) NOT NULL Operation Time Actual Total
12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 OP_INSTRUCTIONS Long Character CLOB Operation Instructions