DBA Data[Home] [Help]

APPS.POS_PO_RCV_QTY dependencies on RCV_TRANSACTIONS

Line 22: FROM rcv_transactions rt

18: BEGIN
19:
20: SELECT nvl(sum(rt.primary_quantity), 0)
21: INTO x_correct_qty
22: FROM rcv_transactions rt
23: WHERE rt.parent_transaction_id = x_parent_trx_id
24: AND rt.transaction_type = 'CORRECT';
25:
26: x_net_qty := x_primary_qty - x_correct_qty;

Line 36: select sum(quantity) into l_quantity from rcv_transactions where

32: FUNCTION get_receive_rcv( x_shipment_line_id in number) return number
33: is
34: l_quantity number;
35: begin
36: select sum(quantity) into l_quantity from rcv_transactions where
37: shipment_line_id = x_shipment_line_id
38: and transaction_type = 'RECEIVE';
39:
40: return l_quantity;

Line 47: * rcv_transactions for the Correct transaction type

43:
44: /* Bug 1086123
45: * We used to call the function get_net_quantity to get
46: * the quantity received in which we the primary_quantity from
47: * rcv_transactions for the Correct transaction type
48: * and x_net_qty := x_net_qty - x_correct_qty;
49: * This is wrong since it should ve x_net_qty + x_correct_qty.
50: * Also now we have to consider RETURN transactions.
51: * So created this new function get_net_qty_rcv which will

Line 52: * be called from the view POS_RCV_TRANSACTIONS_V.

48: * and x_net_qty := x_net_qty - x_correct_qty;
49: * This is wrong since it should ve x_net_qty + x_correct_qty.
50: * Also now we have to consider RETURN transactions.
51: * So created this new function get_net_qty_rcv which will
52: * be called from the view POS_RCV_TRANSACTIONS_V.
53: */
54: FUNCTION get_net_qty_rcv (x_shipment_line_id IN NUMBER,
55: x_primary_qty IN NUMBER
56: ) RETURN NUMBER is

Line 59: FROM rcv_transactions rt, rcv_transactions rt1

55: x_primary_qty IN NUMBER
56: ) RETURN NUMBER is
57: cursor c1(x_shipment_line_id number) is
58: SELECT rt.quantity,rt.transaction_type,rt1.transaction_type
59: FROM rcv_transactions rt, rcv_transactions rt1
60: WHERE rt.shipment_line_id=x_shipment_line_id
61: AND rt1.transaction_id=rt.parent_transaction_id
62: AND rt.transaction_type in ('CORRECT','RETURN TO VENDOR');
63:

Line 110: FROM rcv_transactions

106: SELECT transaction_id,
107: quantity,
108: transaction_type,
109: parent_transaction_id
110: FROM rcv_transactions
111: START WITH transaction_id = c_transaction_id
112: CONNECT BY parent_transaction_id = PRIOR transaction_id;
113:
114: BEGIN

Line 135: FROM rcv_transactions

131: /* The correction function is based on parent transaction type */
132:
133: SELECT transaction_type
134: INTO l_parent_type
135: FROM rcv_transactions
136: WHERE transaction_id = l_parent_id;
137:
138: IF l_parent_type = 'RECEIVE' THEN
139: X_received_quantity := X_received_quantity + l_quantity;