[Home] [Help]
520: l_sql := l_sql || 'select distinct wro.inventory_item_id, ';
521: l_sql := l_sql || ' decode(wro.supply_subinventory, null, ';
522: l_sql := l_sql || ' (decode(msi.wip_supply_subinventory, null, wp.default_pull_supply_subinv, msi.wip_supply_subinventory)),';
523: l_sql := l_sql || ' wro.supply_subinventory) supply_subinventory ';
524: l_sql := l_sql || ' from wip_discrete_jobs wdj, ';
525: l_sql := l_sql || ' wip_requirement_operations wro, ';
526: l_sql := l_sql || ' mtl_system_items msi, ';
527: l_sql := l_sql || ' wip_parameters wp ';
528: l_sql := l_sql || ' where wdj.organization_id = :org_id ';
705: l_sql := l_sql || 'wo.first_unit_start_date, ';
706: l_sql := l_sql || 'wo.scheduled_quantity, ';
707: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as start_qty, ';
708: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as open_qty ';
709: l_sql := l_sql || 'FROM wip_discrete_jobs wdj, ';
710: l_sql := l_sql || 'wip_operations wo ';
711: l_sql := l_sql || 'WHERE wdj.organization_id = :org_id ';
712: l_sql := l_sql || 'AND wdj.scheduled_start_date < :shift_end_time ';
713: l_sql := l_sql || 'AND wo.organization_id = wdj.organization_id ';
1290: where mr.supply_source_type_id = 5 --wip supply
1291: and mr.supply_source_header_id = wdj.wip_entity_id
1292: and mr.organization_id = wdj.organization_id) reservation_qty,
1293: wdj.wip_entity_id --added for bug 6886708 for logging
1294: from wip_discrete_jobs wdj
1295: where wdj.organization_id = p_org_id
1296: and wdj.primary_item_id = p_inv_item_id
1297: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1298: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1357: FUNCTION get_wip_negreq_supply(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) RETURN NUMBER IS
1358: CURSOR wip_negreq_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) IS
1359: select SUM(-1*wro.required_quantity) item_qty
1360: from wip_requirement_operations wro,
1361: wip_discrete_jobs wdj
1362: where wro.organization_id = p_org_id
1363: and wro.inventory_item_id = p_inv_item_id
1364: and trunc(wro.date_required) = trunc(p_rcpt_date)
1365: and wro.organization_id = wdj.organization_id