PO_SSRFQHRLN_VW

(SQL View)
 Index Back

SS eRFQ response line.

Used to select response lines. Found in PO_SSREVINV_WRK.Add_Pb. FieldChange.

SELECT A.BUSINESS_UNIT , A.RFQ_ID , B.LINE_NBR , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.RESPONSE_FLAG , A.DTTM_RESP , A.VENDOR_REF_ID , A.PYMNT_TERMS_CD , A.CNTCT_SEQ_NUM , A.SALES_CNTCT_SEQ_N , A.BILL_LOCATION , A.ADDRESS_SEQ_NUM , B.VNDR_CATALOG_ID , B.ITM_ID_VNDR , B.DESCR254_MIXED , B.QTY_RFQ , B.PRICE_RFQ , B.QTY_MIN , B.SCHED_DATE , B.FREIGHT_TERMS , B.SHIPTO_ID , B.MFG_ID , B.MFG_ITM_ID , B.UNIT_OF_MEASURE , B.CURRENCY_CD , B.RATE_MULT , B.RATE_DIV , B.LEAD_TIME , B.SHIP_TYPE_ID FROM PS_RFQ_RESP_HDR A , PS_RFQ_RESP_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RFQ_ID = B.RFQ_ID AND A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 RESPONSE_FLAG Character(1) VARCHAR2(1) NOT NULL Supplier Responded
8 DTTM_RESP DateTime(26) TIMESTAMP Date Time Responded

Default Value: %date

9 VENDOR_REF_ID Character(20) VARCHAR2(20) NOT NULL Vendor reference quote number
10 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

Prompt Table: PYMT_TR_EFF_VW

11 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: VENDOR_CNTCT_VW

12 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson

Prompt Table: VENDOR_CNTCT_VW

13 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: RFQ_HDR.BILL_LOCATION

Prompt Table: LOCATION_TBL

14 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: VENDOR_ADDR_VW

15 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
16 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
18 QTY_RFQ Number(16,4) DECIMAL(15,4) NOT NULL Qty Request for Quote
19 PRICE_RFQ Number(16,5) DECIMAL(15,5) NOT NULL RFQ Price
20 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
21 SCHED_DATE Date(10) DATE Schedule Date
22 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Default Value: BUS_UNIT_OPT_PM.FREIGHT_TERMS

Prompt Table: FREIGHT_TERMS

23 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Default Value: OPR_DEF_TBL_PM.SHIPTO_ID

Prompt Table: SHIPTO_TBL

24 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

25 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: ITEM_MFG_ID_VW

26 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
28 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
29 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
30 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
31 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Default Value: BUS_UNIT_OPT_PM.SHIP_TYPE_ID

Prompt Table: SHIP_METHOD