APPS.RCV_ROI_TRANSACTION dependencies on RCV_SUPPLY

Line 9421: FROM rcv_supply rsup,

9417: 0 bom_resource_id,
9418: 0 ussgl_transaction_code,
9419: rt.quantity qty,
9420: 0 interface_available_qty
9421: FROM rcv_supply rsup,
9422: rcv_transactions rt,
9423: rcv_shipment_lines rsl,
9424: po_headers poh,
9425: po_lines pol

Line 9528: FROM rcv_supply rsup,

9524: pod.bom_resource_id,
9525: pod.ussgl_transaction_code,
9526: rt.quantity qty,
9527: 0 interface_available_qty
9528: FROM rcv_supply rsup,
9529: rcv_transactions rt,
9530: rcv_shipment_lines rsl,
9531: po_headers poh,
9532: po_lines pol,

Line 9643: FROM rcv_supply rsup,

9639: pod.bom_resource_id,
9640: pod.ussgl_transaction_code,
9641: rt.quantity qty,
9642: 0 interface_available_qty
9643: FROM rcv_supply rsup,
9644: rcv_transactions rt,
9645: rcv_shipment_lines rsl,
9646: po_headers poh,
9647: po_lines pol,

Line 9751: FROM rcv_supply rsup,

9747: pod.bom_resource_id,
9748: pod.ussgl_transaction_code,
9749: rt.quantity qty,
9750: 0 interface_available_qty
9751: FROM rcv_supply rsup,
9752: rcv_transactions rt,
9753: rcv_shipment_lines rsl,
9754: po_headers poh,
9755: po_lines pol,

Line 9788: l_supply_code rcv_supply.supply_type_code%TYPE;

9784: already_derived BOOLEAN := FALSE;
9785: cascaded_table_index NUMBER;
9786: l_num_of_distributions NUMBER;
9787: temp_index NUMBER;
9788: l_supply_code rcv_supply.supply_type_code%TYPE;
9789: l_transaction_type rcv_transactions.transaction_type%TYPE;
9790: /* FPJ SERVICES */
9791: l_value_basis po_lines.order_type_lookup_code%TYPE;
9792: l_purchase_basis po_lines.purchase_basis%TYPE;

Line 9845: rcv_supply rs

9841:
9842: SELECT COUNT(*)
9843: INTO l_num_of_distributions
9844: FROM po_distributions pod,
9845: rcv_supply rs
9846: WHERE pod.line_location_id = rs.po_line_location_id
9847: AND rs.rcv_transaction_id = x_cascaded_table(n).parent_transaction_id;
9848:
9849: IF (l_num_of_distributions = 0) then

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

9847: AND rs.rcv_transaction_id = x_cascaded_table(n).parent_transaction_id;
9848:
9849: IF (l_num_of_distributions = 0) then
9850: /* FP for Bug 4654553.(fixed as a part of bug 5354379)Most probably this is due to non availability
9851: of receiving supply in rcv_supply.Either the items are fully
9852: delivered to inventory or returned back to supplier.
9853: In such a case raise an error and fail the transaction.
9854: */
9855:

Line 10245: FROM rcv_supply

10241: firstrecord := FALSE;
10242:
10243: SELECT quantity
10244: INTO l_total_rec_quantity
10245: FROM rcv_supply
10246: WHERE rcv_transaction_id = x_po_transferrec.rcv_transaction_id
10247: AND supply_type_code = 'RECEIVING';
10248: END IF;
10249:

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

10652: We should not compare the transaction quantity with the po_distributions_all.ordered_quantity,
10653: because we won't be able to do DELIVER txn for the RECEIVE txns with overreceipt made.
10654: If the RECEIVE txn for that DELIVER txns lies in RT, we have to make use of mtl_supply
10655: to get the AVAILABLE quantity for DELIVER txn.
10656: If the RECEIVE txn for that DELIVER txns lies in RTI, there is no mtl_supply or rcv_supply.
10657: So, get the available qty from RTI for that DELIVER txn
10658: */
10659:
10660: IF l_po_deliver_rti_cursor_opened = 1 THEN --{ l_po_deliver_rti_cursor_opened = 1

Line 11491: rcv_supply rsup

11487: rt.customer_site_id,
11488: rt.source_document_code
11489: FROM rcv_transactions rt,
11490: rcv_shipment_lines rsl,
11491: rcv_supply rsup
11492: WHERE rt.transaction_id = v_parent_trx_id
11493: AND rt.transaction_id = rsup.rcv_transaction_id
11494: AND rsup.supply_type_code = 'RECEIVING'
11495: AND rsl.shipment_line_id = rsup.shipment_line_id