DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on WIP_ENTITIES

Line 1691: FROM wip_entities

1687:
1688: BEGIN /* added for Encumbrance Project */
1689: SELECT entity_type
1690: INTO l_entity_type
1691: FROM wip_entities
1692: WHERE wip_entity_id = x_dists.wip_entity_id_tbl(i) ;
1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: l_entity_type := 1; /*if exception, setting entity type to a value <> 6*/

Line 2941: FROM wip_entities

2937: INSERT INTO po_session_gt(key, num1, num2)
2938: SELECT p_key,
2939: p_index_tbl(i),
2940: wip_entity_id
2941: FROM wip_entities
2942: WHERE p_wip_entity_tbl(i) IS NOT NULL
2943: AND x_wip_entity_id_tbl(i) IS NULL
2944: AND p_dest_type_code_tbl(i) = 'SHOP FLOOR'
2945: AND wip_entity_name = p_wip_entity_tbl(i)