VIEW: APPS.POS_ASN_WIP_JOB_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)