APPS.WPS_COMMON dependencies on WIP_DISCRETE_JOBS

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

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

Line 1530: from wip_discrete_jobs

1526: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
1527:
1528: cursor lock_curs is
1529: select wip_entity_id
1530: from wip_discrete_jobs
1531: where wip_entity_id = p_wip_entity_id
1532: and organization_id = p_organization_id
1533: for update nowait;
1534:

Line 1541: from wip_discrete_jobs

1537: begin
1538:
1539: select wip_entity_id
1540: into l_wid
1541: from wip_discrete_jobs
1542: where wip_entity_id = p_wip_entity_id
1543: and organization_id = p_organization_id
1544: for update nowait;
1545:

Line 1552: update wip_discrete_jobs

1548: --fetch lock_curs into l_wid;
1549:
1550: --close lock_curs;
1551:
1552: update wip_discrete_jobs
1553: set scheduling_request_id = p_request_id
1554: where wip_entity_id = p_wip_entity_id
1555: and organization_id = p_organization_id;
1556:

Line 1603: wip_discrete_jobs wdj

1599:
1600: SELECT SUM(((WO.QUANTITY_COMPLETED+wo.QUANTITY_SCRAPPED)/wo.SCHEDULED_QUANTITY)*(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE)),
1601: SUM(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE) into completed, total
1602: from wip_operations wo,
1603: wip_discrete_jobs wdj
1604: where wdj.wip_entity_id = p_wip_entity_id
1605: and wo.wip_entity_id = wdj.wip_entity_id
1606: and wo.organization_id = wdj.organization_id;
1607:

Line 1610: from wip_discrete_jobs

1606: and wo.organization_id = wdj.organization_id;
1607:
1608: if ( total = 0 ) then
1609: select ((QUANTITY_COMPLETED+ QUANTITY_SCRAPPED)/START_QUANTITY) INTO progress
1610: from wip_discrete_jobs
1611: where wip_entity_id = p_wip_entity_id;
1612: else
1613: progress := completed/total;
1614: end if;