View: POS_ASN_WIP_JOB_V

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.POS_ASN_WIP_JOB_V

View Text

SELECT LTRIM(WIPE.WIP_ENTITY_NAME || '-' || WIPL.LINE_CODE || '-' || POD.WIP_OPERATION_SEQ_NUM ) JOB_INFO
, POD.PO_DISTRIBUTION_ID
, POD.WIP_ENTITY_ID
, POD.WIP_LINE_ID
, POD.WIP_OPERATION_SEQ_NUM
, POD.LINE_LOCATION_ID
FROM PO_DISTRIBUTIONS_ALL POD
, WIP_ENTITIES WIPE
, WIP_LINES WIPL
WHERE POD.WIP_ENTITY_ID IS NOT NULL
AND POD.WIP_ENTITY_ID = WIPE.WIP_ENTITY_ID
AND POD.WIP_LINE_ID = WIPL.LINE_ID(+)

Columns