APPS.WIP_WS_SHORTAGE dependencies on WIP_REQUIREMENT_OPERATIONS

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

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

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

843: l_sql := l_sql || ' wro.basis_type, ';
844: l_sql := l_sql || ' wro.wip_supply_type, ';
845: l_sql := l_sql || ' msi.primary_uom_code, ';
846: l_sql := l_sql || ' decode(wp.include_component_yield, 1, nvl(wro.component_yield_factor, 1), 1) ';
847: l_sql := l_sql || ' from wip_requirement_operations wro, ';
848: l_sql := l_sql || ' mtl_system_items msi, ';
849: l_sql := l_sql || ' wip_parameters wp ';
850: l_sql := l_sql || ' where wro.organization_id = :l_org_id ';
851: l_sql := l_sql || ' and wro.wip_entity_id = :l_wip_ent_id ';

Line 1360: from wip_requirement_operations wro,

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