APPS.WMS_WIP_INTEGRATION dependencies on BOM_DEPARTMENTS

Line 2119: bom_departments bd,

2115:
2116: FROM
2117: wip_entities we,
2118: wip_lines wl,
2119: bom_departments bd,
2120: wip_requirement_operations wro,
2121: wip_discrete_jobs wdj,
2122: mtl_txn_request_lines mtrl,
2123: mtl_material_transactions_temp mmtt

Line 2159: bom_departments bd,

2155: x_start_date
2156:
2157: FROM
2158: wip_lines wl,
2159: bom_departments bd,
2160: wip_requirement_operations wro,
2161: wip_repetitive_schedules wrs,
2162: mtl_txn_request_lines mtrl,
2163: mtl_material_transactions_temp mmtt,

Line 2204: bom_departments bd,

2200:
2201: FROM
2202: wip_entities we,
2203: wip_lines wl,
2204: bom_departments bd,
2205: bom_operation_sequences bos,
2206: bom_operational_routings bor,
2207: wip_flow_schedules wfs,
2208: mtl_txn_request_lines mtrl,

Line 2343: bom_departments bd,

2339:
2340: FROM
2341: wip_entities we,
2342: wip_lines wl,
2343: bom_departments bd,
2344: wip_requirement_operations wro,
2345: wip_discrete_jobs wdj,
2346: mtl_material_transactions_temp mmtt
2347: WHERE we.wip_entity_id = wdj.wip_entity_id

Line 2381: bom_departments bd,

2377: x_start_date
2378:
2379: FROM
2380: wip_lines wl,
2381: bom_departments bd,
2382: wip_requirement_operations wro,
2383: wip_repetitive_schedules wrs,
2384: mtl_material_transactions_temp mmtt,
2385: mtl_system_items_kfv msik,

Line 2424: bom_departments bd,

2420:
2421: FROM
2422: wip_entities we,
2423: wip_lines wl,
2424: bom_departments bd,
2425: bom_operation_sequences bos,
2426: bom_operational_routings bor,
2427: wip_flow_schedules wfs,
2428: mtl_material_transactions_temp mmtt

Line 2729: l_department_code bom_departments.department_code%TYPE;

2725: l_organization_id NUMBER;
2726: l_entity_type NUMBER;
2727: l_repetitive_line_id NUMBER;
2728: l_department_id NUMBER;
2729: l_department_code bom_departments.department_code%TYPE;
2730:
2731: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2732: l_project_id NUMBER := NULL ; --Bug6604904
2733: l_task_id NUMBER := NULL ; --Bug6604904

Line 2821: FROM bom_departments bd

2817: SELECT wo.department_id
2818: , bd.department_code
2819: INTO l_department_id
2820: , l_department_code
2821: FROM bom_departments bd
2822: , wip_operations wo
2823: WHERE bd.department_id = wo.department_id
2824: AND wo.wip_entity_id = p_wip_entity_id
2825: AND wo.organization_id = l_organization_id

Line 2832: FROM bom_departments bd

2828: SELECT wo.department_id
2829: , bd.department_code
2830: INTO l_department_id
2831: , l_department_code
2832: FROM bom_departments bd
2833: , wip_operations wo
2834: WHERE bd.department_id = wo.department_id
2835: AND wo.wip_entity_id = p_wip_entity_id
2836: AND wo.organization_id = l_organization_id

Line 2844: FROM bom_departments bd

2840: SELECT bos.department_id
2841: , bd.department_code
2842: INTO l_department_id
2843: , l_department_code
2844: FROM bom_departments bd
2845: , bom_operation_sequences bos
2846: , bom_operational_routings bor
2847: , wip_flow_schedules wfs
2848: WHERE bd.department_id = bos.department_id