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_JOBCLOSE_PRIV dependencies on ORG_ACCT_PERIODS

Line 81: FROM ORG_ACCT_PERIODS AP,

77: DJ.ORGANIZATION_ID,
78: WE.WIP_ENTITY_NAME,
79: DJ.PRIMARY_ITEM_ID,
80: DJ.STATUS_TYPE
81: FROM ORG_ACCT_PERIODS AP,
82: WIP_DISCRETE_JOBS DJ,
83: WIP_ENTITIES WE
84: WHERE DJ.ORGANIZATION_ID = p_organization_id
85: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID

Line 199: FROM ORG_ACCT_PERIODS AP ,

195: DJ.ORGANIZATION_ID ,
196: WE.WIP_ENTITY_NAME ,
197: DJ.PRIMARY_ITEM_ID ,
198: DJ.STATUS_TYPE
199: FROM ORG_ACCT_PERIODS AP ,
200: WIP_DISCRETE_JOBS DJ ,
201: WIP_ENTITIES WE
202: WHERE DJ.ORGANIZATION_ID = p_organization_id
203: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID

Line 296: FROM ORG_ACCT_PERIODS AP,

292: DJ.PRIMARY_ITEM_ID,
293: p_act_close_date,
294: x_group_id
295: BULK COLLECT INTO l_close_temp_tbl2
296: FROM ORG_ACCT_PERIODS AP,
297: WIP_DISCRETE_JOBS DJ,
298: WIP_ENTITIES WE
299: WHERE DJ.ORGANIZATION_ID = p_organization_id
300: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID

Line 1824: FROM ORG_ACCT_PERIODS

1820: to_char(SCHEDULE_CLOSE_DATE,'YYYY/MM/DD')
1821: INTO l_acct_period_id ,
1822: l_per_str_date,
1823: l_per_cls_date
1824: FROM ORG_ACCT_PERIODS
1825: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)
1826: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)
1827: AND ORGANIZATION_ID = p_organization_id;
1828:

Line 2168: FROM ORG_ACCT_PERIODS

2164: BEGIN
2165:
2166: SELECT ACCT_PERIOD_ID
2167: INTO l_acct_period_id
2168: FROM ORG_ACCT_PERIODS
2169: WHERE ORGANIZATION_ID = p_organization_id
2170: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (l_act_close_date,p_organization_id)
2171: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE
2172: AND PERIOD_CLOSE_DATE IS NULL;

Line 2540: FROM ORG_ACCT_PERIODS

2536: BEGIN
2537:
2538: SELECT ACCT_PERIOD_ID
2539: INTO l_acct_period_id
2540: FROM ORG_ACCT_PERIODS
2541: WHERE TRUNC(SYSDATE) >= TRUNC(PERIOD_START_DATE)
2542: AND TRUNC(SYSDATE) <= TRUNC(SCHEDULE_CLOSE_DATE)
2543: AND ORGANIZATION_ID = p_organization_id;
2544:

Line 2558: FROM ORG_ACCT_PERIODS oap

2554: END IF;
2555:
2556: SELECT ACCT_PERIOD_ID
2557: INTO l_acct_period_id
2558: FROM ORG_ACCT_PERIODS oap
2559: WHERE
2560: oap.ORGANIZATION_ID = p_organization_id
2561: AND oap.PERIOD_CLOSE_DATE IS NULL
2562: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(l_acct_period_close_date,to_date(p_act_close_date,'YYYY/MM/DD HH24:MI:SS')),p_organization_id)

Line 2641: ORG_ACCT_PERIODS oap,

2637: wdct.WIP_ENTITY_NAME,
2638: we.ENTITY_TYPE,
2639: wdct.ACTUAL_CLOSE_DATE
2640: FROM WIP_DJ_CLOSE_TEMP wdct,
2641: ORG_ACCT_PERIODS oap,
2642: WIP_ENTITIES we
2643: WHERE wdct.GROUP_ID = l_group_id
2644: AND we.wip_entity_id = wdct.wip_entity_id
2645: AND we.organization_id = p_organization_id