APPS.PO_POXQUAPR_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 262: from rcv_transactions rct

258:
259: begin
260:
261: select sum(rct.primary_quantity) into ret_qty
262: from rcv_transactions rct
263: where rct.transaction_type = 'RETURN TO VENDOR'
264: and rct.po_line_location_id = parent_line_location_id
265: UNION
266: select sum(rct.primary_quantity)

Line 267: from rcv_transactions rct

263: where rct.transaction_type = 'RETURN TO VENDOR'
264: and rct.po_line_location_id = parent_line_location_id
265: UNION
266: select sum(rct.primary_quantity)
267: from rcv_transactions rct
268: where rct.transaction_type = 'RETURN TO VENDOR'
269: and rct.po_line_location_id = parent_line_location_id
270: and Item_id is NULL
271: group by rct.po_line_location_id;

Line 274: from rcv_transactions rct, rcv_transactions rct1

270: and Item_id is NULL
271: group by rct.po_line_location_id;
272:
273: select sum(rct.primary_quantity) into cor_qty
274: from rcv_transactions rct, rcv_transactions rct1
275: where rct.transaction_type = 'CORRECT'
276: and rct.po_line_location_id = parent_line_location_id
277: and rct.parent_transaction_id = rct1.transaction_id
278: and rct1.transaction_type = 'RETURN TO VENDOR'

Line 281: from rcv_transactions rct, rcv_transactions rct1

277: and rct.parent_transaction_id = rct1.transaction_id
278: and rct1.transaction_type = 'RETURN TO VENDOR'
279: UNION
280: select sum(rct.primary_quantity)
281: from rcv_transactions rct, rcv_transactions rct1
282: where rct.transaction_type = 'CORRECT'
283: and rct.po_line_location_id = parent_line_location_id
284: and Item_id is NULL
285: and rct.parent_transaction_id = rct1.transaction_id

Line 310: from rcv_transactions rct

306:
307: begin
308:
309: select sum(rct.primary_quantity) into ins_qty
310: from rcv_transactions rct
311: where rct.transaction_type = 'RETURN TO VENDOR'
312: and nvl(rct.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
313: and rct.po_line_location_id = parent_line_location_id
314: UNION

Line 316: from rcv_transactions rct

312: and nvl(rct.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
313: and rct.po_line_location_id = parent_line_location_id
314: UNION
315: select sum(rct.primary_quantity)
316: from rcv_transactions rct
317: where rct.transaction_type = 'RETURN TO VENDOR'
318: and nvl(rct.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
319: and rct.po_line_location_id = parent_line_location_id
320: and Item_id is NULL

Line 324: from rcv_transactions rct, rcv_transactions rct1

320: and Item_id is NULL
321: group by rct.po_line_location_id;
322:
323: select sum(rct.primary_quantity) into cor_qty
324: from rcv_transactions rct, rcv_transactions rct1
325: where rct.transaction_type = 'CORRECT'
326: and rct.po_line_location_id = parent_line_location_id
327: and rct.parent_transaction_id = rct1.transaction_id
328: and rct1.transaction_type = 'RETURN TO VENDOR'

Line 332: from rcv_transactions rct, rcv_transactions rct1

328: and rct1.transaction_type = 'RETURN TO VENDOR'
329: and nvl(rct1.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
330: UNION
331: select sum(rct.primary_quantity)
332: from rcv_transactions rct, rcv_transactions rct1
333: where rct.transaction_type = 'CORRECT'
334: and rct.po_line_location_id = parent_line_location_id
335: and Item_id is NULL
336: and rct.parent_transaction_id = rct1.transaction_id

Line 362: from rcv_transactions rct

358:
359: begin
360:
361: select sum(rct.primary_quantity) into rec_qty
362: from rcv_transactions rct
363: where rct.transaction_type = 'RECEIVE'
364: and rct.po_line_location_id = parent_line_location_id
365: UNION
366: select sum(rct.primary_quantity)

Line 367: from rcv_transactions rct

363: where rct.transaction_type = 'RECEIVE'
364: and rct.po_line_location_id = parent_line_location_id
365: UNION
366: select sum(rct.primary_quantity)
367: from rcv_transactions rct
368: where rct.transaction_type = 'RECEIVE'
369: and rct.po_line_location_id = parent_line_location_id
370: and Item_id is NULL
371: group by rct.po_line_location_id;

Line 374: from rcv_transactions rct, rcv_transactions rct1

370: and Item_id is NULL
371: group by rct.po_line_location_id;
372:
373: select sum(rct.primary_quantity) into cor_qty
374: from rcv_transactions rct, rcv_transactions rct1
375: where rct.transaction_type = 'CORRECT'
376: and rct.po_line_location_id = parent_line_location_id
377: and rct.parent_transaction_id = rct1.transaction_id
378: and rct1.transaction_type = 'RECEIVE'

Line 381: from rcv_transactions rct, rcv_transactions rct1

377: and rct.parent_transaction_id = rct1.transaction_id
378: and rct1.transaction_type = 'RECEIVE'
379: UNION
380: select sum(rct.primary_quantity)
381: from rcv_transactions rct, rcv_transactions rct1
382: where rct.transaction_type = 'CORRECT'
383: and rct.po_line_location_id = parent_line_location_id
384: and Item_id is NULL
385: and rct.parent_transaction_id = rct1.transaction_id