APPS.WMS_WIP_INTEGRATION dependencies on BOM_DEPARTMENTS

Line 2149: bom_departments bd,

2145:
2146: FROM
2147: wip_entities we,
2148: wip_lines wl,
2149: bom_departments bd,
2150: wip_requirement_operations wro,
2151: wip_discrete_jobs wdj,
2152: mtl_txn_request_lines mtrl,
2153: mtl_material_transactions_temp mmtt

Line 2189: bom_departments bd,

2185: x_start_date
2186:
2187: FROM
2188: wip_lines wl,
2189: bom_departments bd,
2190: wip_requirement_operations wro,
2191: wip_repetitive_schedules wrs,
2192: mtl_txn_request_lines mtrl,
2193: mtl_material_transactions_temp mmtt,

Line 2234: bom_departments bd,

2230:
2231: FROM
2232: wip_entities we,
2233: wip_lines wl,
2234: bom_departments bd,
2235: bom_operation_sequences bos,
2236: bom_operational_routings bor,
2237: wip_flow_schedules wfs,
2238: mtl_txn_request_lines mtrl,

Line 2373: bom_departments bd,

2369:
2370: FROM
2371: wip_entities we,
2372: wip_lines wl,
2373: bom_departments bd,
2374: wip_requirement_operations wro,
2375: wip_discrete_jobs wdj,
2376: mtl_material_transactions_temp mmtt
2377: WHERE we.wip_entity_id = wdj.wip_entity_id

Line 2411: bom_departments bd,

2407: x_start_date
2408:
2409: FROM
2410: wip_lines wl,
2411: bom_departments bd,
2412: wip_requirement_operations wro,
2413: wip_repetitive_schedules wrs,
2414: mtl_material_transactions_temp mmtt,
2415: mtl_system_items_kfv msik,

Line 2454: bom_departments bd,

2450:
2451: FROM
2452: wip_entities we,
2453: wip_lines wl,
2454: bom_departments bd,
2455: bom_operation_sequences bos,
2456: bom_operational_routings bor,
2457: wip_flow_schedules wfs,
2458: mtl_material_transactions_temp mmtt

Line 2759: l_department_code bom_departments.department_code%TYPE;

2755: l_organization_id NUMBER;
2756: l_entity_type NUMBER;
2757: l_repetitive_line_id NUMBER;
2758: l_department_id NUMBER;
2759: l_department_code bom_departments.department_code%TYPE;
2760:
2761: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2762: l_project_id NUMBER := NULL ; --Bug6604904
2763: l_task_id NUMBER := NULL ; --Bug6604904

Line 2851: FROM bom_departments bd

2847: SELECT wo.department_id
2848: , bd.department_code
2849: INTO l_department_id
2850: , l_department_code
2851: FROM bom_departments bd
2852: , wip_operations wo
2853: WHERE bd.department_id = wo.department_id
2854: AND wo.wip_entity_id = p_wip_entity_id
2855: AND wo.organization_id = l_organization_id

Line 2862: FROM bom_departments bd

2858: SELECT wo.department_id
2859: , bd.department_code
2860: INTO l_department_id
2861: , l_department_code
2862: FROM bom_departments bd
2863: , wip_operations wo
2864: WHERE bd.department_id = wo.department_id
2865: AND wo.wip_entity_id = p_wip_entity_id
2866: AND wo.organization_id = l_organization_id

Line 2874: FROM bom_departments bd

2870: SELECT bos.department_id
2871: , bd.department_code
2872: INTO l_department_id
2873: , l_department_code
2874: FROM bom_departments bd
2875: , bom_operation_sequences bos
2876: , bom_operational_routings bor
2877: , wip_flow_schedules wfs
2878: WHERE bd.department_id = bos.department_id