[Home] [Help]
2113: x_dept,
2114: x_operation_seq_num
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,
2161: wip_repetitive_schedules wrs,
2162: mtl_txn_request_lines mtrl,
2163: mtl_material_transactions_temp mmtt,
2164: mtl_system_items_kfv msik,
2165: wip_entities we
2166: WHERE msik.inventory_item_id = we.primary_item_id
2167: AND msik.organization_id = we.organization_id
2168: AND we.wip_entity_id = wrs.wip_entity_id
2169: AND we.organization_id = wrs.organization_id
2198: x_dept,
2199: x_operation_seq_num
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,
2313: x_wip_entity_id := l_wip_entity_id;
2314:
2315: SELECT entity_type
2316: INTO l_wip_entity_type
2317: FROM wip_entities
2318: WHERE organization_id = l_org_id
2319: AND wip_entity_id = l_wip_entity_id;
2320:
2321:
2337: x_dept,
2338: x_operation_seq_num
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,
2382: wip_requirement_operations wro,
2383: wip_repetitive_schedules wrs,
2384: mtl_material_transactions_temp mmtt,
2385: mtl_system_items_kfv msik,
2386: wip_entities we
2387: WHERE msik.inventory_item_id = we.primary_item_id
2388: AND msik.organization_id = we.organization_id
2389: AND we.wip_entity_id = wrs.wip_entity_id
2390: AND we.organization_id = wrs.organization_id
2418: x_dept,
2419: x_operation_seq_num
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,
2769: -- entity type
2770: BEGIN
2771: SELECT entity_type
2772: INTO l_entity_type
2773: FROM wip_entities
2774: WHERE wip_entity_id = p_wip_entity_id
2775: AND organization_id = l_organization_id;
2776: EXCEPTION
2777: WHEN OTHERS THEN