APPS.INV_RCV_AVAILABILITY dependencies on RCV_TRANSACTIONS

Line 81: , rcv_transactions rt

77: BEGIN
78: SELECT Nvl(SUM(rs.to_org_primary_quantity),0)
79: INTO l_supply_prim_qty
80: FROM rcv_supply rs
81: , rcv_transactions rt
82: WHERE rs.supply_source_id = rt.transaction_id
83: AND rs.supply_type_code = 'RECEIVING'
84: AND rs.to_organization_id = p_organization_id
85: AND rs.item_id = p_item_id

Line 144: FROM rcv_transactions_interface rti

140:
141: BEGIN
142: SELECT Nvl(ABS(SUM(primary_quantity)),0)
143: INTO l_rti_primary_quantity
144: FROM rcv_transactions_interface rti
145: WHERE to_organization_id = p_organization_id
146: AND item_id = p_item_id
147:
148: --10/04/05: Reservations are not created on the revision level, so

Line 154: AND NOT exists (SELECT '1' FROM rcv_transactions rt

150: --that case, don't use revision as a query criteria
151: AND NVL(item_revision, '@@@') = NVL(p_revision,NVL(item_revision, '@@@'))
152: AND rti.processing_status_code <> 'ERROR'
153: AND rti.transaction_status_code <> 'ERROR'
154: AND NOT exists (SELECT '1' FROM rcv_transactions rt
155: WHERE rt.interface_transaction_id = rti.interface_transaction_id)
156: AND (TRANSACTION_TYPE = 'DELIVER'
157: OR (TRANSACTION_TYPE IN ('RETURN TO VENDOR','RETURN TO CUSTOMER')
158: AND EXISTS (SELECT '1' FROM rcv_transactions rt

Line 158: AND EXISTS (SELECT '1' FROM rcv_transactions rt

154: AND NOT exists (SELECT '1' FROM rcv_transactions rt
155: WHERE rt.interface_transaction_id = rti.interface_transaction_id)
156: AND (TRANSACTION_TYPE = 'DELIVER'
157: OR (TRANSACTION_TYPE IN ('RETURN TO VENDOR','RETURN TO CUSTOMER')
158: AND EXISTS (SELECT '1' FROM rcv_transactions rt
159: WHERE rt.transaction_id = rti.parent_transaction_id
160: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT','TRANSFER')))
161: OR (TRANSACTION_TYPE IN ('CORRECT')
162: AND quantity < 0

Line 163: AND EXISTS (SELECT '1' FROM rcv_transactions rt

159: WHERE rt.transaction_id = rti.parent_transaction_id
160: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT','TRANSFER')))
161: OR (TRANSACTION_TYPE IN ('CORRECT')
162: AND quantity < 0
163: AND EXISTS (SELECT '1' FROM rcv_transactions rt
164: WHERE rt.transaction_id = rti.parent_transaction_id
165: AND rt.transaction_type IN ('RECEIVE')))
166: OR (TRANSACTION_TYPE IN ('CORRECT')
167: AND quantity > 0

Line 168: AND EXISTS (SELECT '1' FROM rcv_transactions rt

164: WHERE rt.transaction_id = rti.parent_transaction_id
165: AND rt.transaction_type IN ('RECEIVE')))
166: OR (TRANSACTION_TYPE IN ('CORRECT')
167: AND quantity > 0
168: AND EXISTS (SELECT '1' FROM rcv_transactions rt
169: WHERE rt.transaction_id = rti.parent_transaction_id
170: AND rt.transaction_type IN ('DELIVER'))));
171: EXCEPTION
172: WHEN OTHERS THEN