APPS.POS_WCAPPROVE_PVT dependencies on RCV_TRANSACTIONS

Line 4023: from rcv_transactions

4019: END IF;
4020: If (l_matching_basis = 'AMOUNT') then--{
4021: select nvl(sum(amount),0)
4022: into l_transacted_amount
4023: from rcv_transactions
4024: where po_distribution_id=
4025: wcr_line_info.po_distribution_id
4026: and transaction_type = 'RECEIVE';
4027:

Line 4035: from rcv_transactions_interface

4031: l_transacted_amount );
4032: END IF;
4033: select nvl(sum(amount),0)
4034: into l_interface_amount
4035: from rcv_transactions_interface
4036: where po_distribution_id=
4037: wcr_line_info.po_distribution_id
4038: and processing_status_code='PENDING'
4039: and transaction_status_code = 'PENDING'

Line 4113: from rcv_transactions

4109: end if; --l_available_amount >0}
4110: elsif (l_matching_basis = 'QUANTITY') then --}{
4111: select nvl(sum(quantity),0)
4112: into l_transacted_quantity
4113: from rcv_transactions
4114: where po_distribution_id=
4115: wcr_line_info.po_distribution_id
4116: and transaction_type = 'RECEIVE';
4117:

Line 4126: from rcv_transactions_interface

4122: END IF;
4123:
4124: select nvl(sum(quantity),0)
4125: into l_interface_quantity
4126: from rcv_transactions_interface
4127: where po_distribution_id=
4128: wcr_line_info.po_distribution_id
4129: and processing_status_code='PENDING'
4130: and transaction_status_code = 'PENDING'

Line 4214: select rcv_transactions_interface_s.nextval

4210: end if; --}l_available_quantity >0
4211: end if; --}
4212:
4213: If (l_insert_into_rti) then --{
4214: select rcv_transactions_interface_s.nextval
4215: into l_interface_id
4216: from dual;
4217:
4218: IF (g_asn_debug = 'Y') THEN

Line 4598: UPDATE rcv_transactions_interface

4594: END IF;
4595: if (l_result_id <= 0 or l_result_id is null) then
4596:
4597:
4598: UPDATE rcv_transactions_interface
4599: set transaction_status_code = 'ERROR'
4600: where group_id = l_group_id;
4601:
4602: