DBA Data[Home] [Help]

APPS.GME_TRANSFORM_BATCH dependencies on SY_ORGN_MST

Line 113: FROM sy_orgn_mst sy

109: PROCEDURE create_gme_parameters(p_migration_run_id IN NUMBER,
110: x_exception_count OUT NOCOPY NUMBER) IS
111: CURSOR get_plant_and_labs IS
112: SELECT sy.organization_id, sy.orgn_code plant_code
113: FROM sy_orgn_mst sy
114: WHERE NOT EXISTS (SELECT 1
115: FROM gme_parameters
116: WHERE organization_id = sy.organization_id)
117: AND sy.organization_id IS NOT NULL;

Line 267: FROM sy_orgn_mst org

263: x_exception_count OUT NOCOPY NUMBER) IS
264: BEGIN
265: UPDATE gme_batch_header h
266: SET laboratory_ind = (SELECT DECODE (org.plant_ind, 1, 0, 2, 1)
267: FROM sy_orgn_mst org
268: WHERE org.orgn_code = h.plant_code),
269: migrated_batch_ind = 'Y'
270: WHERE laboratory_ind IS NULL;
271: gma_common_logging.gma_migration_central_log