APPS.GMD_STABILITY_STUDIES_GRP dependencies on DUAL

Line 463: FROM DUAL ;

459: SELECT l_source_organization_code ||
460: decode(l_source_organization_code,NULL,NULL,decode(cr_material_src_variant_rec.lot_number || cr_material_src_variant_rec.recipe_no,NULL,NULL,'-')) || -- INVCONV
461: cr_material_src_variant_rec.lot_number || decode(cr_material_src_variant_rec.lot_number,NULL,NULL,decode(cr_material_src_variant_rec.recipe_no,NULL,NULL,'-')) || -- INVCONV
462: cr_material_src_variant_rec.recipe_no INTO l_source_label
463: FROM DUAL ;
464:
465: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_VAR_MISSING','SOURCE',l_source_label);
466: x_return_status := FND_API.G_RET_STS_ERROR ;
467: RETURN;

Line 568: FROM DUAL ;

564: SELECT l_source_organization_code ||
565: decode(l_source_organization_code,NULL,NULL,decode(cr_material_src_smpl_event_rec.lot_number || cr_material_src_smpl_event_rec.recipe_no,NULL,NULL,'-')) || -- INVCONV
566: cr_material_src_smpl_event_rec.lot_number || decode(cr_material_src_smpl_event_rec.lot_number,NULL,NULL,decode(cr_material_src_smpl_event_rec.recipe_no,NULL,NULL,'-')) || -- INVCONV
567: cr_material_src_smpl_event_rec.recipe_no INTO l_source_label
568: FROM DUAL ;
569:
570: IF cr_material_src_smpl_event_rec.lot_number IS NULL THEN
571: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_LOT_MISSING','SOURCE',l_source_label);
572: ELSE

Line 594: FROM DUAL ;

590: SELECT l_source_organization_code ||
591: decode(l_source_organization_code,NULL,NULL,decode(cr_material_src_yield_date_rec.lot_number || cr_material_src_yield_date_rec.recipe_no,NULL,NULL,'-')) || -- INVCONV
592: cr_material_src_yield_date_rec.lot_number || decode(cr_material_src_yield_date_rec.lot_number,NULL,NULL,decode(cr_material_src_yield_date_rec.recipe_no,NULL,NULL,'-')) ||
593: cr_material_src_yield_date_rec.recipe_no INTO l_source_label
594: FROM DUAL ;
595:
596: IF cr_material_src_yield_date_rec.yield_date IS NULL THEN
597: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_YIELD_MISSING','SOURCE',l_source_label);
598: ELSE