DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on WIP_DISCRETE_JOBS

Line 1465: from mtl_reservations mr, oe_order_lines_all ool, wip_discrete_jobs wdj

1461: so_name := '';
1462:
1463: select count(distinct ool.sold_to_org_id), count(distinct mr.demand_source_header_id)
1464: into cust_cnt, so_cnt
1465: from mtl_reservations mr, oe_order_lines_all ool, wip_discrete_jobs wdj
1466: where mr.demand_source_line_id = ool.line_id
1467: and mr.demand_source_type_id = 2
1468: and mr.supply_source_type_id = 5
1469: and mr.supply_source_header_id = p_wip_entity_id

Line 1526: from wip_discrete_jobs

1522: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
1523:
1524: cursor lock_curs is
1525: select wip_entity_id
1526: from wip_discrete_jobs
1527: where wip_entity_id = p_wip_entity_id
1528: and organization_id = p_organization_id
1529: for update nowait;
1530:

Line 1537: from wip_discrete_jobs

1533: begin
1534:
1535: select wip_entity_id
1536: into l_wid
1537: from wip_discrete_jobs
1538: where wip_entity_id = p_wip_entity_id
1539: and organization_id = p_organization_id
1540: for update nowait;
1541:

Line 1548: update wip_discrete_jobs

1544: --fetch lock_curs into l_wid;
1545:
1546: --close lock_curs;
1547:
1548: update wip_discrete_jobs
1549: set scheduling_request_id = p_request_id
1550: where wip_entity_id = p_wip_entity_id
1551: and organization_id = p_organization_id;
1552:

Line 1598: from wip_discrete_jobs

1594:
1595: BEGIN
1596:
1597: select start_quantity into start_qty
1598: from wip_discrete_jobs
1599: where wip_entity_id = p_wip_entity_id;
1600:
1601: if (start_qty = 0) then
1602: progress := 0;

Line 1609: wip_discrete_jobs wdj

1605:
1606: SELECT SUM(((WO.QUANTITY_COMPLETED+wo.QUANTITY_SCRAPPED)/wo.SCHEDULED_QUANTITY)*(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE)),
1607: SUM(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE) into completed, total
1608: from wip_operations wo,
1609: wip_discrete_jobs wdj
1610: where wdj.wip_entity_id = p_wip_entity_id
1611: and wo.wip_entity_id = wdj.wip_entity_id
1612: and wo.organization_id = wdj.organization_id;
1613:

Line 1616: from wip_discrete_jobs

1612: and wo.organization_id = wdj.organization_id;
1613:
1614: if ( total = 0 ) then
1615: select ((QUANTITY_COMPLETED+ QUANTITY_SCRAPPED)/START_QUANTITY) INTO progress
1616: from wip_discrete_jobs
1617: where wip_entity_id = p_wip_entity_id;
1618: else
1619: progress := completed/total;
1620: end if;

Line 1767: from wip_discrete_jobs wdj

1763:
1764: /* check if job needs to be updated */
1765: select wdj.scheduled_start_date, wdj.scheduled_completion_date
1766: into l_old_start_date, l_old_completion_date
1767: from wip_discrete_jobs wdj
1768: where wdj.wip_entity_id = p_wip_entity_id
1769: for update;
1770:
1771: if( l_old_start_date > p_new_start_date or

Line 1786: update wip_discrete_jobs wdj

1782: else
1783: l_new_completion_date := p_new_completion_date;
1784: end if;
1785:
1786: update wip_discrete_jobs wdj
1787: set wdj.scheduled_start_date = l_new_start_date,
1788: wdj.scheduled_completion_date = l_new_completion_date,
1789: wdj.last_update_date = sysdate
1790: where wdj.wip_entity_id = p_wip_entity_id;

Line 1938: from wip_discrete_jobs wdj

1934:
1935: /* check if job needs to be updated */
1936: select wdj.scheduled_start_date, wdj.scheduled_completion_date
1937: into l_old_start_date, l_old_completion_date
1938: from wip_discrete_jobs wdj
1939: where wdj.wip_entity_id = p_wip_entity_id
1940: for update;
1941:
1942: if( l_old_start_date > p_new_start_date or

Line 1957: update wip_discrete_jobs wdj

1953: else
1954: l_new_completion_date := p_new_completion_date;
1955: end if;
1956:
1957: update wip_discrete_jobs wdj
1958: set wdj.scheduled_start_date = l_new_start_date,
1959: wdj.scheduled_completion_date = l_new_completion_date,
1960: wdj.last_update_date = sysdate
1961: where wdj.wip_entity_id = p_wip_entity_id;