APPS.RCV_FTE_CALL_PVT dependencies on RCV_FTE_TRANSACTION_LINES

Line 128: FROM rcv_fte_transaction_lines

124: IF (l_is_asn IS NOT NULL)
125: THEN
126: SELECT count(*)
127: INTO l_has_receipt
128: FROM rcv_fte_transaction_lines
129: WHERE action = 'RECEIPT'
130: AND reported_flag = 'Y'
131: AND header_id = p_shipment_header_id;
132:

Line 145: FROM rcv_fte_transaction_lines

141: -- with the same header_id as this receipt,
142: -- then this is a RECEIPT_ADD
143: SELECT count(*)
144: INTO l_has_receipt
145: FROM rcv_fte_transaction_lines
146: WHERE action = 'RECEIPT_ADD'
147: AND header_id = p_shipment_header_id;
148:
149: IF (l_has_receipt > 0)

Line 208: FROM rcv_fte_transaction_lines a, rcv_fte_transaction_lines b

204: l_msg_count NUMBER;
205: l_msg_data VARCHAR2(2000);
206: CURSOR all_calls IS
207: SELECT a.header_id, a.action
208: FROM rcv_fte_transaction_lines a, rcv_fte_transaction_lines b
209: WHERE a.reported_flag IN ('N','U')
210: AND a.header_id = b.header_id
211: AND b.reported_flag = 'N'
212: GROUP BY a.header_id, a.action;