APPS.POA_EDW_RCV_TXNS_PKG dependencies on RCV_TRANSACTIONS

Line 29: from rcv_transactions

25: end if;
26:
27: /*First, sum all quantities of this txn_type before correction */
28: select sum(nvl(source_doc_quantity, 0)) into l_sum
29: from rcv_transactions
30: where shipment_line_id = p_shipment_line_id
31: and transaction_type = p_transaction_type;
32:
33: l_qty := l_qty + nvl(l_sum, 0);

Line 37: from rcv_transactions rcv1

33: l_qty := l_qty + nvl(l_sum, 0);
34:
35: /*Then, take corrections into account */
36: select sum(nvl(rcv1.source_doc_quantity, 0)) into l_sum
37: from rcv_transactions rcv1
38: where rcv1.parent_transaction_id in
39: (select transaction_id
40: from rcv_transactions rcv2
41: where rcv2.shipment_line_id = p_shipment_line_id

Line 40: from rcv_transactions rcv2

36: select sum(nvl(rcv1.source_doc_quantity, 0)) into l_sum
37: from rcv_transactions rcv1
38: where rcv1.parent_transaction_id in
39: (select transaction_id
40: from rcv_transactions rcv2
41: where rcv2.shipment_line_id = p_shipment_line_id
42: and rcv2.transaction_type = p_transaction_type)
43: and rcv1.transaction_type = 'CORRECT';
44:

Line 69: from rcv_transactions

65: return (0);
66: end if;
67:
68: select sum(nvl(source_doc_quantity, 0)) into l_sum
69: from rcv_transactions
70: where parent_transaction_id = p_transaction_id
71: and transaction_type = 'CORRECT';
72:
73: l_qty := l_qty + nvl(l_sum, 0);

Line 101: from rcv_transactions

97:
98: cursor txn_cur (p_pid in NUMBER) IS
99: select transaction_id, nvl(source_doc_quantity, 0) s_qty,
100: transaction_type
101: from rcv_transactions
102: where parent_transaction_id = p_pid;
103:
104: BEGIN
105: if p_parent_txn_id is NULL OR

Line 121: from rcv_transactions

117:
118: if p_transaction_type <> 'CORRECT' then
119: /* take account for corrections */
120: select sum(nvl(source_doc_quantity, 0)) into l_qty_cor_sum
121: from rcv_transactions
122: where parent_transaction_id = l_txn_id
123: and transaction_type = 'CORRECT';
124:
125: l_qty := l_qty + nvl(l_qty_cor_sum, 0);

Line 155: from rcv_transactions

151:
152: BEGIN
153:
154: select max(transaction_date) into l_date
155: from rcv_transactions
156: where shipment_line_id = p_shipment_line_id
157: and transaction_type = 'DELIVER';
158:
159: return l_date;