APPS.PO_SHIPMENTS_SV7 dependencies on PO_DISTRIBUTIONS

Line 27: FROM po_distributions

23: ** destination type as SHOP FLOOR or INVENTORY */
24:
25: SELECT count(*)
26: INTO X_count
27: FROM po_distributions
28: WHERE line_location_id = X_line_location_id
29: AND po_line_id = X_po_line_id
30: AND po_header_id = X_po_header_id
31: AND destination_type_code IN ('SHOP FLOOR','INVENTORY')

Line 112: from po_distributions

108: X_Progress := '010';
109:
110: select count(*)
111: into X_dist_num
112: from po_distributions
113: where line_location_id = X_line_location_id;
114:
115: X_Progress := '020';
116:

Line 120: from po_distributions

116:
117: if X_dist_num = 1 then
118: select code_combination_id
119: into X_code_combination_id
120: from po_distributions
121: where line_location_id = X_line_location_id;
122: end if;
123:
124: exception