DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_SV1 dependencies on PO_LOCATIONS_VAL_V

Line 147: /* get the location_id from po_locations_val_v view based on the

143: BEGIN
144:
145: X_progress := '010';
146:
147: /* get the location_id from po_locations_val_v view based on the
148: location_code and location_usages which are provided from
149: input parameter */
150:
151: SELECT location_id

Line 153: FROM po_locations_val_v

149: input parameter */
150:
151: SELECT location_id
152: INTO X_location_id_v
153: FROM po_locations_val_v
154: WHERE location_code = X_location_code
155: AND DECODE(X_location_usage,
156: 'SHIP_TO', NVL(ship_to_site_flag,'N'),
157: 'BILL_TO', NVL(bill_to_site_flag,'N'),

Line 192: FROM po_locations_val_v

188: on the location type. ***/
189:
190: SELECT count(*)
191: INTO x_temp
192: FROM po_locations_val_v
193: WHERE location_id = X_location_id
194: AND DECODE(X_location_type,
195: 'SHIP_TO', NVL(ship_to_site_flag, 'N'),
196: 'BILL_TO', NVL(bill_to_site_flag, 'N'),