APPS.RCV_ROI_TRANSACTION dependencies on RCV_SUPPLY

Line 10443: FROM rcv_supply rsup,

10439: 0 bom_resource_id,
10440: 0 ussgl_transaction_code,
10441: rt.quantity qty,
10442: 0 interface_available_qty
10443: FROM rcv_supply rsup,
10444: rcv_transactions rt,
10445: rcv_shipment_lines rsl,
10446: po_headers poh,
10447: po_lines pol

Line 10550: FROM rcv_supply rsup,

10546: pod.bom_resource_id,
10547: pod.ussgl_transaction_code,
10548: rt.quantity qty,
10549: 0 interface_available_qty
10550: FROM rcv_supply rsup,
10551: rcv_transactions rt,
10552: rcv_shipment_lines rsl,
10553: po_headers poh,
10554: po_lines pol,

Line 10665: FROM rcv_supply rsup,

10661: pod.bom_resource_id,
10662: pod.ussgl_transaction_code,
10663: rt.quantity qty,
10664: 0 interface_available_qty
10665: FROM rcv_supply rsup,
10666: rcv_transactions rt,
10667: rcv_shipment_lines rsl,
10668: po_headers poh,
10669: po_lines pol,

Line 10773: FROM rcv_supply rsup,

10769: pod.bom_resource_id,
10770: pod.ussgl_transaction_code,
10771: rt.quantity qty,
10772: 0 interface_available_qty
10773: FROM rcv_supply rsup,
10774: rcv_transactions rt,
10775: rcv_shipment_lines rsl,
10776: po_headers poh,
10777: po_lines pol,

Line 10830: l_supply_code rcv_supply.supply_type_code%TYPE;

10826: already_derived BOOLEAN := FALSE;
10827: cascaded_table_index NUMBER;
10828: l_num_of_distributions NUMBER;
10829: temp_index NUMBER;
10830: l_supply_code rcv_supply.supply_type_code%TYPE;
10831: l_transaction_type rcv_transactions.transaction_type%TYPE;
10832: /* FPJ SERVICES */
10833: l_value_basis po_lines.order_type_lookup_code%TYPE;
10834: l_purchase_basis po_lines.purchase_basis%TYPE;

Line 10928: rcv_supply rs

10924:
10925: SELECT COUNT(*)
10926: INTO l_num_of_distributions
10927: FROM po_distributions pod,
10928: rcv_supply rs
10929: WHERE pod.line_location_id = rs.po_line_location_id
10930: AND rs.rcv_transaction_id = x_cascaded_table(n).parent_transaction_id;
10931:
10932: IF (l_num_of_distributions = 0) then

Line 10934: of receiving supply in rcv_supply.Either the items are fully

10930: AND rs.rcv_transaction_id = x_cascaded_table(n).parent_transaction_id;
10931:
10932: IF (l_num_of_distributions = 0) then
10933: /* FP for Bug 4654553.(fixed as a part of bug 5354379)Most probably this is due to non availability
10934: of receiving supply in rcv_supply.Either the items are fully
10935: delivered to inventory or returned back to supplier.
10936: In such a case raise an error and fail the transaction.
10937: */
10938:

Line 11308: FROM rcv_supply

11304: firstrecord := FALSE;
11305:
11306: SELECT quantity
11307: INTO l_total_rec_quantity
11308: FROM rcv_supply
11309: WHERE rcv_transaction_id = x_po_transferrec.rcv_transaction_id
11310: AND supply_type_code = 'RECEIVING';
11311: END IF;
11312:

Line 11768: If the RECEIVE txn for that DELIVER txns lies in RTI, there is no mtl_supply or rcv_supply.

11764: We should not compare the transaction quantity with the po_distributions_all.ordered_quantity,
11765: because we won't be able to do DELIVER txn for the RECEIVE txns with overreceipt made.
11766: If the RECEIVE txn for that DELIVER txns lies in RT, we have to make use of mtl_supply
11767: to get the AVAILABLE quantity for DELIVER txn.
11768: If the RECEIVE txn for that DELIVER txns lies in RTI, there is no mtl_supply or rcv_supply.
11769: So, get the available qty from RTI for that DELIVER txn
11770: */
11771:
11772: IF l_po_deliver_rti_cursor_opened = 1 THEN --{ l_po_deliver_rti_cursor_opened = 1

Line 12787: rcv_supply rsup

12783: rt.customer_site_id,
12784: rt.source_document_code
12785: FROM rcv_transactions rt,
12786: rcv_shipment_lines rsl,
12787: rcv_supply rsup
12788: WHERE rt.transaction_id = v_parent_trx_id
12789: AND rt.transaction_id = rsup.rcv_transaction_id
12790: AND rsup.supply_type_code = 'RECEIVING'
12791: AND rsl.shipment_line_id = rsup.shipment_line_id