APPS.POS_WCAPPROVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

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 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: