APPS.POS_OSP_JOB dependencies on WIP_LINES

Line 31: wip_lines wipl

27: select ltrim(wipe.wip_entity_name || '-' || wipl.line_code || '-' || pod.wip_operation_seq_num)
28: into job_info
29: from po_distributions_all pod,
30: wip_entities wipe,
31: wip_lines wipl
32: where pod.line_location_id = po_line_location_id and
33: pod.wip_entity_id is not null and
34: pod.wip_entity_id = wipe.wip_entity_id and
35: pod.wip_line_id = wipl.line_id(+);

Line 59: wip_lines wipl

55: select ltrim(wipe.wip_entity_name || '-' || wipl.line_code || '-' || pod.wip_operation_seq_num)
56: into job_info
57: from po_distributions_all pod,
58: wip_entities wipe,
59: wip_lines wipl
60: where pod.po_distribution_id = po_distributions_id and
61: pod.wip_entity_id is not null and
62: pod.wip_entity_id = wipe.wip_entity_id and
63: pod.wip_line_id = wipl.line_id(+);