APPS.WIP_WS_SHORTAGE dependencies on WIP_REQUIREMENT_OPERATIONS

Line 526: l_sql := l_sql || ' wip_requirement_operations wro, ';

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 ';
530: l_sql := l_sql || ' and wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped > 0 ';

Line 888: l_sql := l_sql || ' from wip_requirement_operations wro, ';

884: l_sql := l_sql || ' wro.basis_type, ';
885: l_sql := l_sql || ' wro.wip_supply_type, ';
886: l_sql := l_sql || ' msi.primary_uom_code, ';
887: l_sql := l_sql || ' decode(wp.include_component_yield, 1, nvl(wro.component_yield_factor, 1), 1) ';
888: l_sql := l_sql || ' from wip_requirement_operations wro, ';
889: l_sql := l_sql || ' mtl_system_items msi, ';
890: l_sql := l_sql || ' wip_parameters wp ';
891: l_sql := l_sql || ' where wro.organization_id = :l_org_id ';
892: l_sql := l_sql || ' and wro.wip_entity_id = :l_wip_ent_id ';

Line 1431: from wip_requirement_operations wro,

1427: */
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)