PV_RECV_BU_VW(SQL View) |
Index Back |
|---|---|
PV_RECV_BU_VWDate Initials Reference # Description 07/31/2008 Jer 1695402003 Corrected the display of Receiving Business Unit in the Create Receipt Page. |
| SELECT DISTINCT PO.BUSINESS_UNIT_REQ , PO.REQ_ID , H.BUSINESS_UNIT FROM PS_RECV_HDR H , PS_RECV_LN_SHIP S , PS_PO_LINE_DISTRIB PO WHERE S.PO_ID <> ' ' AND H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.RECEIVER_ID = S.RECEIVER_ID AND S.AMT_ONLY_FLG = 'N' AND S.BUSINESS_UNIT_PO = PO.BUSINESS_UNIT AND S.PO_ID = PO.PO_ID AND S.LINE_NBR = PO.LINE_NBR AND S.SCHED_NBR = PO.SCHED_NBR AND S.QTY_SH_ACCPT_VUOM > 0 AND S.QTY_SH_NETRCV_VUOM > 0 AND S.QTY_SH_RTN_VUOM < S.QTY_SH_ACCPT_VUOM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |