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_JSI_VALIDATOR dependencies on BOM_CALENDAR_DATES

Line 1433: from bom_calendar_dates bcd, mtl_parameters mp

1429: end if;
1430: if(wjsi_row.first_unit_start_date is not null) then
1431: select 1
1432: into g_dummy
1433: from bom_calendar_dates bcd, mtl_parameters mp
1434: where mp.organization_id = wjsi_row.organization_id
1435: and mp.calendar_code = bcd.calendar_code
1436: and mp.calendar_exception_set_id = bcd.exception_set_id
1437: and bcd.calendar_date = trunc(wjsi_row.first_unit_start_date);

Line 1442: from bom_calendar_dates bcd, mtl_parameters mp

1438: end if;
1439: if(wjsi_row.last_unit_completion_date is not null) then
1440: select 1
1441: into g_dummy
1442: from bom_calendar_dates bcd, mtl_parameters mp
1443: where mp.organization_id = wjsi_row.organization_id
1444: and mp.calendar_code = bcd.calendar_code
1445: and mp.calendar_exception_set_id = bcd.exception_set_id
1446: and bcd.calendar_date = trunc(wjsi_row.last_unit_completion_date);

Line 1536: from bom_calendar_dates bcd, mtl_parameters mp

1532: -- sugupta 26th-May-2006
1533: /*
1534: select calendar_date
1535: into wjsi_row.first_unit_start_date
1536: from bom_calendar_dates bcd, mtl_parameters mp
1537: where mp.organization_id = wjsi_row.organization_id
1538: and bcd.exception_set_id = mp.calendar_exception_set_id
1539: and bcd.calendar_code = mp.calendar_code
1540: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1541: from bom_calendar_dates b2

1537: where mp.organization_id = wjsi_row.organization_id
1538: and bcd.exception_set_id = mp.calendar_exception_set_id
1539: and bcd.calendar_code = mp.calendar_code
1540: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
1541: from bom_calendar_dates b2
1542: where b2.calendar_date = trunc(wjsi_row.last_unit_start_date)
1543: and b2.calendar_code = bcd.calendar_code
1544: and b2.exception_set_id = bcd.exception_set_id);
1545: */

Line 1548: FROM bom_calendar_dates bcd,

1544: and b2.exception_set_id = bcd.exception_set_id);
1545: */
1546: SELECT bcd.calendar_date
1547: INTO wjsi_row.first_unit_start_date
1548: FROM bom_calendar_dates bcd,
1549: mtl_parameters mp,
1550: bom_calendar_dates b2
1551: WHERE mp.organization_id = wjsi_row.organization_id
1552: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 1550: bom_calendar_dates b2

1546: SELECT bcd.calendar_date
1547: INTO wjsi_row.first_unit_start_date
1548: FROM bom_calendar_dates bcd,
1549: mtl_parameters mp,
1550: bom_calendar_dates b2
1551: WHERE mp.organization_id = wjsi_row.organization_id
1552: and bcd.exception_set_id = mp.calendar_exception_set_id
1553: and bcd.calendar_code = mp.calendar_code
1554: and bcd.seq_num = b2.prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1564: from bom_calendar_dates bcd, mtl_parameters mp

1560: -- sugupta 26th-May-2006
1561: /*
1562: select calendar_date
1563: into wjsi_row.last_unit_start_date
1564: from bom_calendar_dates bcd, mtl_parameters mp
1565: where mp.organization_id = wjsi_row.organization_id
1566: and bcd.exception_set_id = mp.calendar_exception_set_id
1567: and bcd.calendar_code = mp.calendar_code
1568: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1569: from bom_calendar_dates b2

1565: where mp.organization_id = wjsi_row.organization_id
1566: and bcd.exception_set_id = mp.calendar_exception_set_id
1567: and bcd.calendar_code = mp.calendar_code
1568: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
1569: from bom_calendar_dates b2
1570: where b2.calendar_date = trunc(wjsi_row.first_unit_start_date)
1571: and b2.calendar_code = bcd.calendar_code
1572: and b2.exception_set_id = bcd.exception_set_id);
1573: */

Line 1576: FROM bom_calendar_dates bcd,

1572: and b2.exception_set_id = bcd.exception_set_id);
1573: */
1574: SELECT bcd.calendar_date
1575: INTO wjsi_row.last_unit_start_date
1576: FROM bom_calendar_dates bcd,
1577: mtl_parameters mp,
1578: bom_calendar_dates b2
1579: WHERE mp.organization_id = wjsi_row.organization_id
1580: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 1578: bom_calendar_dates b2

1574: SELECT bcd.calendar_date
1575: INTO wjsi_row.last_unit_start_date
1576: FROM bom_calendar_dates bcd,
1577: mtl_parameters mp,
1578: bom_calendar_dates b2
1579: WHERE mp.organization_id = wjsi_row.organization_id
1580: and bcd.exception_set_id = mp.calendar_exception_set_id
1581: and bcd.calendar_code = mp.calendar_code
1582: and bcd.seq_num = b2.prior_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1592: from bom_calendar_dates bcd, mtl_parameters mp

1588: -- sugupta 26th-May-2006
1589: /*
1590: select calendar_date
1591: into wjsi_row.first_unit_completion_date
1592: from bom_calendar_dates bcd, mtl_parameters mp
1593: where mp.organization_id = wjsi_row.organization_id
1594: and bcd.exception_set_id = mp.calendar_exception_set_id
1595: and bcd.calendar_code = mp.calendar_code
1596: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1597: from bom_calendar_dates b2

1593: where mp.organization_id = wjsi_row.organization_id
1594: and bcd.exception_set_id = mp.calendar_exception_set_id
1595: and bcd.calendar_code = mp.calendar_code
1596: and seq_num = (select prior_seq_num - ceil(wjsi_row.processing_work_days)+1
1597: from bom_calendar_dates b2
1598: where b2.calendar_date = trunc(wjsi_row.last_unit_completion_date)
1599: and b2.calendar_code = bcd.calendar_code
1600: and b2.exception_set_id = bcd.exception_set_id);
1601: */

Line 1604: FROM bom_calendar_dates bcd,

1600: and b2.exception_set_id = bcd.exception_set_id);
1601: */
1602: SELECT bcd.calendar_date
1603: INTO wjsi_row.first_unit_completion_date
1604: FROM bom_calendar_dates bcd,
1605: mtl_parameters mp,
1606: bom_calendar_dates b2
1607: WHERE mp.organization_id = wjsi_row.organization_id
1608: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 1606: bom_calendar_dates b2

1602: SELECT bcd.calendar_date
1603: INTO wjsi_row.first_unit_completion_date
1604: FROM bom_calendar_dates bcd,
1605: mtl_parameters mp,
1606: bom_calendar_dates b2
1607: WHERE mp.organization_id = wjsi_row.organization_id
1608: and bcd.exception_set_id = mp.calendar_exception_set_id
1609: and bcd.calendar_code = mp.calendar_code
1610: and bcd.seq_num = b2.prior_seq_num - ceil(wjsi_row.processing_work_days)+1

Line 1620: from bom_calendar_dates bcd, mtl_parameters mp

1616: -- sugupta 26th-May-2006
1617: /*
1618: select calendar_date
1619: into wjsi_row.last_unit_completion_date
1620: from bom_calendar_dates bcd, mtl_parameters mp
1621: where mp.organization_id = wjsi_row.organization_id
1622: and bcd.exception_set_id = mp.calendar_exception_set_id
1623: and bcd.calendar_code = mp.calendar_code
1624: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1

Line 1625: from bom_calendar_dates b2

1621: where mp.organization_id = wjsi_row.organization_id
1622: and bcd.exception_set_id = mp.calendar_exception_set_id
1623: and bcd.calendar_code = mp.calendar_code
1624: and seq_num = (select next_seq_num + ceil(wjsi_row.processing_work_days)-1
1625: from bom_calendar_dates b2
1626: where b2.calendar_date = trunc(wjsi_row.first_unit_completion_date)
1627: and b2.calendar_code = bcd.calendar_code
1628: and b2.exception_set_id = bcd.exception_set_id) ;
1629: */

Line 1632: FROM bom_calendar_dates bcd,

1628: and b2.exception_set_id = bcd.exception_set_id) ;
1629: */
1630: SELECT bcd.calendar_date
1631: INTO wjsi_row.last_unit_completion_date
1632: FROM bom_calendar_dates bcd,
1633: mtl_parameters mp,
1634: bom_calendar_dates b2
1635: WHERE mp.organization_id = wjsi_row.organization_id
1636: and bcd.exception_set_id = mp.calendar_exception_set_id

Line 1634: bom_calendar_dates b2

1630: SELECT bcd.calendar_date
1631: INTO wjsi_row.last_unit_completion_date
1632: FROM bom_calendar_dates bcd,
1633: mtl_parameters mp,
1634: bom_calendar_dates b2
1635: WHERE mp.organization_id = wjsi_row.organization_id
1636: and bcd.exception_set_id = mp.calendar_exception_set_id
1637: and bcd.calendar_code = mp.calendar_code
1638: and bcd.seq_num = b2.prior_seq_num + ceil(wjsi_row.processing_work_days)-1