[Home] [Help]
2143: x_dept,
2144: x_operation_seq_num
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,
2191: wip_repetitive_schedules wrs,
2192: mtl_txn_request_lines mtrl,
2193: mtl_material_transactions_temp mmtt,
2194: mtl_system_items_kfv msik,
2195: wip_entities we
2196: WHERE msik.inventory_item_id = we.primary_item_id
2197: AND msik.organization_id = we.organization_id
2198: AND we.wip_entity_id = wrs.wip_entity_id
2199: AND we.organization_id = wrs.organization_id
2228: x_dept,
2229: x_operation_seq_num
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,
2343: x_wip_entity_id := l_wip_entity_id;
2344:
2345: SELECT entity_type
2346: INTO l_wip_entity_type
2347: FROM wip_entities
2348: WHERE organization_id = l_org_id
2349: AND wip_entity_id = l_wip_entity_id;
2350:
2351:
2367: x_dept,
2368: x_operation_seq_num
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,
2412: wip_requirement_operations wro,
2413: wip_repetitive_schedules wrs,
2414: mtl_material_transactions_temp mmtt,
2415: mtl_system_items_kfv msik,
2416: wip_entities we
2417: WHERE msik.inventory_item_id = we.primary_item_id
2418: AND msik.organization_id = we.organization_id
2419: AND we.wip_entity_id = wrs.wip_entity_id
2420: AND we.organization_id = wrs.organization_id
2448: x_dept,
2449: x_operation_seq_num
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,
2799: -- entity type
2800: BEGIN
2801: SELECT entity_type
2802: INTO l_entity_type
2803: FROM wip_entities
2804: WHERE wip_entity_id = p_wip_entity_id
2805: AND organization_id = l_organization_id;
2806: EXCEPTION
2807: WHEN OTHERS THEN