eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_TRANSACTIONS_PUB dependencies on ORG_ACCT_PERIODS

Line 703: l_acct_period_id org_acct_periods.acct_period_id%TYPE;

699: l_transaction_action_id mtl_transaction_types.transaction_action_id%TYPE;
700: l_transaction_source_type_id mtl_transaction_types.transaction_source_type_id%TYPE;
701: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;
702: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;
703: l_acct_period_id org_acct_periods.acct_period_id%TYPE;
704: l_transaction_date date;
705: l_quantity NUMBER;
706: l_account_id NUMBER;
707: l_code_comb_id NUMBER;

Line 812: FROM org_acct_periods

808: SELECT acct_period_id,
809: least(sysdate,
810: decode(sign(trunc(period_start_date)-(trunc(p_transaction_date))),
811: 1,sysdate,p_transaction_date)) transaction_date
812: FROM org_acct_periods
813: WHERE (trunc(p_transaction_date)
814: between trunc(period_start_date)
815: and trunc(schedule_close_date)
816: OR trunc(sysdate)