Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.RCV_RECEIVING_PARAMETERS_V |
SELECT RP.ROWID
, RP.ORGANIZATION_ID
, RP.LAST_UPDATE_DATE
, RP.LAST_UPDATED_BY
, RP.CREATION_DATE
, RP.CREATED_BY
, RP.LAST_UPDATED_LOGIN
, RP.QTY_RCV_TOLERANCE
, RP.QTY_RCV_EXCEPTION_CODE
, RP.ENFORCE_SHIP_TO_LOCATION_CODE
, RP.ALLOW_EXPRESS_DELIVERY_FLAG
, RP.DAYS_EARLY_RECEIPT_ALLOWED
, RP.DAYS_LATE_RECEIPT_ALLOWED
, RP.RECEIPT_DAYS_EXCEPTION_CODE
, RP.RECEIVING_ROUTING_ID
, RRH.ROUTING_NAME
, RP.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, RP.ALLOW_UNORDERED_RECEIPTS_FLAG
, RP.BLIND_RECEIVING_FLAG
, RP.REQUEST_ID
, RP.PROGRAM_APPLICATION_ID
, RP.PROGRAM_ID
, RP.PROGRAM_UPDATE_DATE
, RP.RECEIVING_ACCOUNT_ID
, RP.ALLOW_CASCADE_TRANSACTIONS
, RP.RECEIPT_ASN_EXISTS_CODE
, RP.USER_DEFINED_RECEIPT_NUM_CODE
, RP.MANUAL_RECEIPT_NUM_TYPE
, RP.NEXT_RECEIPT_NUM
, RP.RETROPRICE_ADJ_ACCOUNT_ID
, RP.CLEARING_ACCOUNT_ID
, RP.ENFORCE_RMA_SERIAL_NUM
, RP.RMA_RECEIPT_ROUTING_ID
, RRH1.ROUTING_NAME RMA_ROUTING_NAME
, RP.ENFORCE_RMA_LOT_NUM
FROM RCV_PARAMETERS RP
, RCV_ROUTING_HEADERS RRH
, RCV_ROUTING_HEADERS RRH1
WHERE RP.RECEIVING_ROUTING_ID = RRH.ROUTING_HEADER_ID (+)
AND RP.RMA_RECEIPT_ROUTING_ID = RRH1.ROUTING_HEADER_ID(+)