View: SO_PICKING_BATCHES_VIEW_V

View Text

SELECT SPH.ROWID ROW_ID
, SPH.CREATION_DATE CREATION_DATE
, SPH.CREATED_BY CREATED_BY
, SPH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SPH.LAST_UPDATED_BY LAST_UPDATED_BY
, SPH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SPH.PICKING_HEADER_ID PICKING_HEADER_ID
, SPLD.PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, SPH.DATE_SHIPPED DATE_SHIPPED
, SPH.WAYBILL_NUM WAYBILL_NUM
, SPH.SHIP_METHOD_CODE SHIP_METHOD_CODE
, SPH.NUMBER_OF_BOXES NUMBER_OF_BOXES
, SPH.WEIGHT_UNIT_CODE WEIGHT_UNIT_CODE
, SPH.WEIGHT WEIGHT
, SPH.ORDER_HEADER_ID ORDER_HEADER_ID
, SPH.DATE_RELEASED DATE_RELEASED
, PB.NAME BATCH
, DECODE(PB.DATE_COMPLETED
, ''
, 'N'
, 'Y' ) COMPLETE_FLAG
, MP.ORGANIZATION_CODE WAREHOUSE
, RSU.LOCATION SHIP_TO
, RSU.ADDRESS_ID ADDRESS_ID
, RA.ADDRESS1 || ' ' || RA.ADDRESS2 || ' ' || RA.ADDRESS3 || ' ' || RA.ADDRESS4 SHIP_ADDRESS1
, RA.CITY || '
, ' ||RA.STATE || ' ' ||RA.POSTAL_CODE SHIP_ADDRESS2
, RC.CUSTOMER_NAME CUSTOMER_NAME
, RCS.FIRST_NAME || ' ' || RCS.LAST_NAME SHIP_CONTACT
, RP.PHONE_ID SHIP_PHONE_ID
FROM SO_PICKING_HEADERS SPH
, SO_PICKING_BATCHES PB
, SO_PICKING_LINES SPL
, SO_PICKING_LINE_DETAILS SPLD
, RA_SITE_USES RSU
, RA_ADDRESSES RA
, RA_CUSTOMERS RC
, ORG_FREIGHT ORGF
, MTL_PARAMETERS MP
, SO_HEADERS SH
, RA_CONTACTS RCS
, RA_PHONES RP
WHERE PB.BATCH_ID(+) = SPH.BATCH_ID
AND RC.CUSTOMER_ID(+) = RA.CUSTOMER_ID
AND RA.ADDRESS_ID(+) = RSU.ADDRESS_ID
AND RSU.SITE_USE_ID(+) = SPH.SHIP_TO_SITE_USE_ID
AND ORGF.ORGANIZATION_ID(+) = FND_PROFILE.VALUE('SO_ORGANIZATION_ID' )
AND ORGF.FREIGHT_CODE(+) = SPH.SHIP_METHOD_CODE
AND MP.ORGANIZATION_ID(+) = SPH.WAREHOUSE_ID
AND SH.HEADER_ID(+) = SPH.ORDER_HEADER_ID
AND RCS.CONTACT_ID(+) = SH.SHIP_TO_CONTACT_ID
AND RP.CONTACT_ID(+) = SH.SHIP_TO_CONTACT_ID
AND NVL(RP.PRIMARY_FLAG(+)
, 'N')='Y'
AND SPH.PICKING_HEADER_ID = SPL.PICKING_HEADER_ID
AND SPL.PICKING_LINE_ID = SPLD.PICKING_LINE_ID

Columns