[Home] [Help]
6: begin
7:
8: select count(*)
9: into x_count
10: from po_distributions_all
11: where line_location_id = po_line_location_id and
12: wip_entity_id is not null;
13:
14: return x_count;
25: if x_count = 1 then
26:
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
53: begin
54:
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
73: if r_count(po_line_location_id) = 1 then
74:
75: select po_distribution_id
76: into x_id
77: from po_distributions_all
78: where line_location_id = po_line_location_id and
79: wip_entity_id is not null;
80:
81: return x_id;
92: if r_count(po_line_location_id) = 1 then
93:
94: select wip_entity_id
95: into x_id
96: from po_distributions_all
97: where line_location_id = po_line_location_id and
98: wip_entity_id is not null;
99:
100: return x_id;
111: if r_count(po_line_location_id) = 1 then
112:
113: select wip_operation_seq_num
114: into x_id
115: from po_distributions_all
116: where line_location_id = po_line_location_id and
117: wip_entity_id is not null;
118:
119: return x_id;
130: if r_count(po_line_location_id) = 1 then
131:
132: select wip_line_id
133: into x_id
134: from po_distributions_all
135: where line_location_id = po_line_location_id and
136: wip_entity_id is not null;
137:
138: return x_id;