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.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on WIP_PERIOD_BALANCES

Line 1546: INSERT INTO WIP_PERIOD_BALANCES

1542: industry => l_wip_indust)) THEN
1543:
1544: /* make insert into wpb using starting time and end time */
1545: /* for discrete */
1546: INSERT INTO WIP_PERIOD_BALANCES
1547: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
1548: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
1549: LAST_UPDATED_BY, CREATION_DATE,
1550: CREATED_BY, LAST_UPDATE_LOGIN,

Line 1585: (select 'X' from wip_period_balances wpb

1581: or (WDJ.DATE_RELEASED between l_start_time and l_end_time)
1582: or (WDJ.LAST_UPDATE_DATE between l_start_time and l_end_time)
1583: )
1584: AND not exists
1585: (select 'X' from wip_period_balances wpb
1586: where l_new_acct_period_id = wpb.acct_period_id
1587: and wpb.organization_id = p_org_hierarchy_origin
1588: and wdj.wip_entity_id = wpb.wip_entity_id);
1589:

Line 1591: INSERT INTO WIP_PERIOD_BALANCES

1587: and wpb.organization_id = p_org_hierarchy_origin
1588: and wdj.wip_entity_id = wpb.wip_entity_id);
1589:
1590: /* for repetitive schedules */
1591: INSERT INTO WIP_PERIOD_BALANCES
1592: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
1593: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
1594: LAST_UPDATED_BY, CREATION_DATE,
1595: CREATED_BY, LAST_UPDATE_LOGIN,

Line 1624: (select 'X' from wip_period_balances wpb

1620: AND WRS.ORGANIZATION_ID = p_org_hierarchy_origin
1621: AND ((WRS.CREATION_DATE between l_start_time and l_end_time)
1622: or (WRS.DATE_RELEASED between l_start_time and l_end_time))
1623: AND not exists
1624: (select 'X' from wip_period_balances wpb
1625: where l_new_acct_period_id = wpb.acct_period_id
1626: and wpb.organization_id = p_org_hierarchy_origin
1627: and wrs.wip_entity_id = wpb.wip_entity_id
1628: and wrs.repetitive_schedule_id = wpb.repetitive_schedule_id);

Line 2006: INSERT INTO WIP_PERIOD_BALANCES

2002: industry => l_wip_indust)) THEN
2003:
2004: /* make insert into wpb using starting time and end time */
2005: /* for discrete */
2006: INSERT INTO WIP_PERIOD_BALANCES
2007: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
2008: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
2009: LAST_UPDATED_BY, CREATION_DATE,
2010: CREATED_BY, LAST_UPDATE_LOGIN,

Line 2043: (select 'X' from wip_period_balances wpb

2039: AND WAC.ORGANIZATION_ID = l_orgid
2040: AND ((WDJ.CREATION_DATE between l_start_time and l_end_time)
2041: or (WDJ.DATE_RELEASED between l_start_time and l_end_time))
2042: AND not exists
2043: (select 'X' from wip_period_balances wpb
2044: where l_new_acct_period_id = wpb.acct_period_id
2045: and wpb.organization_id = l_orgid
2046: and wdj.wip_entity_id = wpb.wip_entity_id);
2047:

Line 2049: INSERT INTO WIP_PERIOD_BALANCES

2045: and wpb.organization_id = l_orgid
2046: and wdj.wip_entity_id = wpb.wip_entity_id);
2047:
2048: /* for repetitive schedules */
2049: INSERT INTO WIP_PERIOD_BALANCES
2050: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
2051: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
2052: LAST_UPDATED_BY, CREATION_DATE,
2053: CREATED_BY, LAST_UPDATE_LOGIN,

Line 2082: (select 'X' from wip_period_balances wpb

2078: AND WRS.ORGANIZATION_ID = l_orgid
2079: AND ((WRS.CREATION_DATE between l_start_time and l_end_time)
2080: or (WRS.DATE_RELEASED between l_start_time and l_end_time))
2081: AND not exists
2082: (select 'X' from wip_period_balances wpb
2083: where l_new_acct_period_id = wpb.acct_period_id
2084: and wpb.organization_id = l_orgid
2085: and wrs.wip_entity_id = wpb.wip_entity_id
2086: and wrs.repetitive_schedule_id = wpb.repetitive_schedule_id);