VIEW: APPS.POFV_INBOUND_SHIPMENTS

Source

View Text - Preformatted

SELECT SH.SHIPMENT_HEADER_ID, SH.SHIPMENT_NUM, SH.RECEIPT_NUM, SH.EXPECTED_RECEIPT_DATE, SH.SHIPPED_DATE, '_LA:sh.RECEIPT_SOURCE_CODE:PO_LOOKUP_CODES:SHIPMENT SOURCE TYPE:DISPLAYED_FIELD', SH.ASN_TYPE, SH.CONVERSION_RATE, SH.CONVERSION_DATE, SH.COMMENTS, SH.NUM_OF_CONTAINERS, SH.BILL_OF_LADING, SH.WAYBILL_AIRBILL_NUM, SH.FREIGHT_AMOUNT, SH.INVOICE_STATUS_CODE, SH.INVOICE_AMOUNT, SH.INVOICE_DATE, SH.INVOICE_NUM, SH.TAX_AMOUNT, SH.TAX_NAME, SH.EDI_CONTROL_NUM, SH.NOTICE_CREATION_DATE, SH.PACKING_SLIP, SH.GROSS_WEIGHT, SH.NET_WEIGHT, SH.USSGL_TRANSACTION_CODE, '_DF:PO:RCV_SHIPMENT_HEADERS:sh', SH.VENDOR_ID, VE.VENDOR_NAME, SH.ORGANIZATION_ID, SC.ORGANIZATION_CODE, SO.NAME, SH.SHIP_TO_LOCATION_ID, LO.LOCATION_CODE, SH.CURRENCY_CODE, CU.NAME, SH.CONVERSION_RATE_TYPE, RT.USER_CONVERSION_TYPE, RT.DESCRIPTION, SH.GROSS_WEIGHT_UOM_CODE, GU.UOM_CLASS, GU.DESCRIPTION, SH.NET_WEIGHT_UOM_CODE, NU.UOM_CLASS, NU.DESCRIPTION, SH.FREIGHT_CARRIER_CODE, FR.DESCRIPTION, SH.EMPLOYEE_ID, RV.EMPLOYEE_NUMBER, RV.FULL_NAME, SH.PAYMENT_TERMS_ID, PT.NAME, SH.CREATION_DATE, SH.CREATED_BY, SH.LAST_UPDATE_DATE, SH.LAST_UPDATED_BY FROM RCV_SHIPMENT_HEADERS SH, GL_DAILY_CONVERSION_TYPES RT, FND_CURRENCIES_VL CU, MTL_UNITS_OF_MEASURE GU, MTL_UNITS_OF_MEASURE NU, PO_VENDORS VE, HR_ALL_ORGANIZATION_UNITS SO, MTL_PARAMETERS SC, HR_LOCATIONS LO, ORG_FREIGHT FR, PER_PEOPLE_F RV, AP_TERMS PT WHERE SH.CONVERSION_RATE_TYPE = RT.CONVERSION_TYPE(+) AND SH.CURRENCY_CODE = CU.CURRENCY_CODE(+) AND SH.GROSS_WEIGHT_UOM_CODE = GU.UNIT_OF_MEASURE(+) AND SH.NET_WEIGHT_UOM_CODE = NU.UNIT_OF_MEASURE(+) AND SH.VENDOR_ID = VE.VENDOR_ID(+) AND SH.ORGANIZATION_ID = SO.ORGANIZATION_ID(+) AND SH.ORGANIZATION_ID = SC.ORGANIZATION_ID(+) AND SH.SHIP_TO_LOCATION_ID = LO.LOCATION_ID(+) AND SH.FREIGHT_CARRIER_CODE = FR.FREIGHT_CODE(+) AND SH.ORGANIZATION_ID = FR.ORGANIZATION_ID(+) AND SH.EMPLOYEE_ID = RV.PERSON_ID(+) AND RV.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE) AND RV.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE) AND SH.PAYMENT_TERMS_ID = PT.TERM_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT SH.SHIPMENT_HEADER_ID
, SH.SHIPMENT_NUM
, SH.RECEIPT_NUM
, SH.EXPECTED_RECEIPT_DATE
, SH.SHIPPED_DATE
, '_LA:SH.RECEIPT_SOURCE_CODE:PO_LOOKUP_CODES:SHIPMENT SOURCE TYPE:DISPLAYED_FIELD'
, SH.ASN_TYPE
, SH.CONVERSION_RATE
, SH.CONVERSION_DATE
, SH.COMMENTS
, SH.NUM_OF_CONTAINERS
, SH.BILL_OF_LADING
, SH.WAYBILL_AIRBILL_NUM
, SH.FREIGHT_AMOUNT
, SH.INVOICE_STATUS_CODE
, SH.INVOICE_AMOUNT
, SH.INVOICE_DATE
, SH.INVOICE_NUM
, SH.TAX_AMOUNT
, SH.TAX_NAME
, SH.EDI_CONTROL_NUM
, SH.NOTICE_CREATION_DATE
, SH.PACKING_SLIP
, SH.GROSS_WEIGHT
, SH.NET_WEIGHT
, SH.USSGL_TRANSACTION_CODE
, '_DF:PO:RCV_SHIPMENT_HEADERS:SH'
, SH.VENDOR_ID
, VE.VENDOR_NAME
, SH.ORGANIZATION_ID
, SC.ORGANIZATION_CODE
, SO.NAME
, SH.SHIP_TO_LOCATION_ID
, LO.LOCATION_CODE
, SH.CURRENCY_CODE
, CU.NAME
, SH.CONVERSION_RATE_TYPE
, RT.USER_CONVERSION_TYPE
, RT.DESCRIPTION
, SH.GROSS_WEIGHT_UOM_CODE
, GU.UOM_CLASS
, GU.DESCRIPTION
, SH.NET_WEIGHT_UOM_CODE
, NU.UOM_CLASS
, NU.DESCRIPTION
, SH.FREIGHT_CARRIER_CODE
, FR.DESCRIPTION
, SH.EMPLOYEE_ID
, RV.EMPLOYEE_NUMBER
, RV.FULL_NAME
, SH.PAYMENT_TERMS_ID
, PT.NAME
, SH.CREATION_DATE
, SH.CREATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
FROM RCV_SHIPMENT_HEADERS SH
, GL_DAILY_CONVERSION_TYPES RT
, FND_CURRENCIES_VL CU
, MTL_UNITS_OF_MEASURE GU
, MTL_UNITS_OF_MEASURE NU
, PO_VENDORS VE
, HR_ALL_ORGANIZATION_UNITS SO
, MTL_PARAMETERS SC
, HR_LOCATIONS LO
, ORG_FREIGHT FR
, PER_PEOPLE_F RV
, AP_TERMS PT
WHERE SH.CONVERSION_RATE_TYPE = RT.CONVERSION_TYPE(+)
AND SH.CURRENCY_CODE = CU.CURRENCY_CODE(+)
AND SH.GROSS_WEIGHT_UOM_CODE = GU.UNIT_OF_MEASURE(+)
AND SH.NET_WEIGHT_UOM_CODE = NU.UNIT_OF_MEASURE(+)
AND SH.VENDOR_ID = VE.VENDOR_ID(+)
AND SH.ORGANIZATION_ID = SO.ORGANIZATION_ID(+)
AND SH.ORGANIZATION_ID = SC.ORGANIZATION_ID(+)
AND SH.SHIP_TO_LOCATION_ID = LO.LOCATION_ID(+)
AND SH.FREIGHT_CARRIER_CODE = FR.FREIGHT_CODE(+)
AND SH.ORGANIZATION_ID = FR.ORGANIZATION_ID(+)
AND SH.EMPLOYEE_ID = RV.PERSON_ID(+)
AND RV.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND RV.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND SH.PAYMENT_TERMS_ID = PT.TERM_ID(+) WITH READ ONLY