DBA Data[Home] [Help]

APPS.MTL_MOVEMENT_RPT_PKG dependencies on RA_CUSTOMER_TRX

Line 86: from ra_customer_trx

82: and l_movement_type in ('D','DA'))
83: then
84: begin
85: select exchange_rate into l_exchange_rate
86: from ra_customer_trx
87: where customer_trx_id = l_invoice_id;
88: exception when no_data_found
89: then l_exchange_rate := null;
90: end;

Line 159: from ra_customer_trx

155: and l_movement_type in ('D','DA'))
156: then
157: begin
158: select exchange_date into l_exchange_date
159: from ra_customer_trx
160: where customer_trx_id = l_invoice_id;
161: exception when no_data_found
162: then l_exchange_date := null;
163: end;

Line 355: from ra_customer_trx

351: and mms.invoice_id is not null;
352: --
353: update mtl_movement_statistics mms
354: set invoice_date_reference = (select trx_date
355: from ra_customer_trx
356: where customer_trx_id = mms.invoice_id)
357: where mms.movement_type = P_MOVEMENT_TYPE
358: and mms.entity_org_id = P_LEGAL_ENTITY_ID
359: and mms.movement_status = 'O'