[Home] [Help]
521: l_sql := l_sql || 'select distinct wro.inventory_item_id, ';
522: l_sql := l_sql || ' decode(wro.supply_subinventory, null, ';
523: l_sql := l_sql || ' (decode(msi.wip_supply_subinventory, null, wp.default_pull_supply_subinv, msi.wip_supply_subinventory)),';
524: l_sql := l_sql || ' wro.supply_subinventory) supply_subinventory ';
525: l_sql := l_sql || ' from wip_discrete_jobs wdj, ';
526: l_sql := l_sql || ' wip_requirement_operations wro, ';
527: l_sql := l_sql || ' mtl_system_items msi, ';
528: l_sql := l_sql || ' wip_parameters wp ';
529: l_sql := l_sql || ' where wdj.organization_id = :org_id ';
746: l_sql := l_sql || 'wo.first_unit_start_date, ';
747: l_sql := l_sql || 'wo.scheduled_quantity, ';
748: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as start_qty, ';
749: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as open_qty ';
750: l_sql := l_sql || 'FROM wip_discrete_jobs wdj, ';
751: l_sql := l_sql || 'wip_operations wo ';
752: l_sql := l_sql || 'WHERE wdj.organization_id = :org_id ';
753: l_sql := l_sql || 'AND wdj.scheduled_start_date < :shift_end_time ';
754: l_sql := l_sql || 'AND wo.organization_id = wdj.organization_id ';
1361: where mr.supply_source_type_id = 5 --wip supply
1362: and mr.supply_source_header_id = wdj.wip_entity_id
1363: and mr.organization_id = wdj.organization_id) reservation_qty,
1364: wdj.wip_entity_id --added for bug 6886708 for logging
1365: from wip_discrete_jobs wdj
1366: where wdj.organization_id = p_org_id
1367: and wdj.primary_item_id = p_inv_item_id
1368: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1369: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1428: FUNCTION get_wip_negreq_supply(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) RETURN NUMBER IS
1429: CURSOR wip_negreq_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) IS
1430: select SUM(-1*wro.required_quantity) item_qty
1431: from wip_requirement_operations wro,
1432: wip_discrete_jobs wdj
1433: where wro.organization_id = p_org_id
1434: and wro.inventory_item_id = p_inv_item_id
1435: and trunc(wro.date_required) = trunc(p_rcpt_date)
1436: and wro.organization_id = wdj.organization_id