DBA Data[Home] [Help]

APPS.RCV_RECEIPTS_QUERY_SV dependencies on RCV_QUANTITIES_S

Line 125: rcv_quantities_s.get_available_quantity ('RECEIVE',

121: IF nvl(x_asn_type,'STD') NOT IN ('ASN','ASBN','LCM') THEN -- ASN Phase 2 -- lcm changes
122: IF (x_receipt_source_code = 'VENDOR') THEN
123:
124: /* Bug# 1548597 */
125: rcv_quantities_s.get_available_quantity ('RECEIVE',
126: x_line_location_id,
127: 'VENDOR', NULL, NULL, NULL, x_available_qty,
128: x_tolerable_qty, x_uom, X_secondary_available_qty);
129:

Line 189: rcv_quantities_s.get_available_rma_quantity('RECEIVE',

185: For use if we need to account for pending transactions in the interface
186: table.
187: */
188: /* Bug# 1548597 */
189: rcv_quantities_s.get_available_rma_quantity('RECEIVE',
190: null,
191: 'CUSTOMER',
192: null,null,null,
193: x_oe_order_header_id,

Line 202: rcv_quantities_s.get_available_quantity ('RECEIVE',

198: X_secondary_available_qty);
199:
200: ELSE -- INTERNAL
201: /* Bug# 1548597 */
202: rcv_quantities_s.get_available_quantity ('RECEIVE',
203: x_shipment_line_id,
204: 'INVENTORY', NULL, NULL, NULL, x_available_qty,
205: x_tolerable_qty, x_uom, X_secondary_available_qty);
206:

Line 223: rcv_quantities_s.get_available_quantity ('RECEIVE',

219: ** like an internal transfer so the code changes are
220: ** minimal and making use of existing API
221: */
222: /* Bug# 1548597 */
223: rcv_quantities_s.get_available_quantity ('RECEIVE',
224: x_shipment_line_id,
225: 'INVENTORY', NULL, NULL, NULL, x_available_qty,
226: x_tolerable_qty, x_uom, X_secondary_available_qty);
227:

Line 235: rcv_quantities_s.get_available_quantity ('RECEIVE',

231: ** receive more than what was stated on the asn since it all
232: ** gets applied to the shipment line as receipt quantity anyway.
233: */
234: /* Bug# 1548597 */
235: rcv_quantities_s.get_available_quantity ('RECEIVE',
236: x_line_location_id,
237: 'VENDOR', NULL, NULL, NULL, x_available_qty_hold,
238: x_tolerable_qty, x_uom_hold, X_secondary_available_qty);
239:

Line 261: rcv_quantities_s.get_ship_qty_in_int(x_shipment_line_id, x_line_location_id, x_ship_qty_in_int);

257: there can be potential double counting, we need to add qty that are both
258: against the PO shipment and ASN shipment in RTI, this would only happen when we are using
259: BATCH mode */
260:
261: rcv_quantities_s.get_ship_qty_in_int(x_shipment_line_id, x_line_location_id, x_ship_qty_in_int);
262:
263: /* the real tolerable qty should be as follows */
264:
265: x_tolerable_qty := x_tolerable_qty - X_quantity_shipped + x_available_qty + x_ship_qty_in_int ;