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.WIP_MOVE_VALIDATOR dependencies on ORG_ACCT_PERIODS

Line 742: FROM ORG_ACCT_PERIODS OAP

738: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
739: AND wmti.process_status = WIP_CONSTANTS.RUNNING
740: AND NOT EXISTS
741: (SELECT 'X'
742: FROM ORG_ACCT_PERIODS OAP
743: WHERE OAP.ORGANIZATION_ID = WMTI.ORGANIZATION_ID
744: AND OAP.PERIOD_CLOSE_DATE IS NULL
745: AND OAP.OPEN_FLAG = 'Y'
746: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(

Line 795: FROM org_acct_periods oap

791: -- Derive ACCT_PERIOD_ID from TRANSACTION_DATE
792: UPDATE wip_move_txn_interface wmti
793: SET wmti.acct_period_id =
794: (SELECT oap.acct_period_id
795: FROM org_acct_periods oap
796: WHERE oap.organization_id = wmti.organization_id
797: -- modified the statement below for timezone project in J
798: AND TRUNC(inv_le_timezone_pub.get_le_day_for_inv_org(
799: wmti.transaction_date, -- p_trxn_date

Line 3168: FROM org_acct_periods oap

3164: -- Derive ACCT_PERIOD_ID from TRANSACTION_DATE
3165: UPDATE wip_move_txn_interface wmti
3166: SET wmti.acct_period_id =
3167: (SELECT oap.acct_period_id
3168: FROM org_acct_periods oap
3169: WHERE oap.organization_id = wmti.organization_id
3170: -- modified the statement below for timezone project in J
3171: AND TRUNC(inv_le_timezone_pub.get_le_day_for_inv_org(
3172: wmti.transaction_date, -- p_trxn_date