DBA Data[Home] [Help]

APPS.GMPMRACT dependencies on IC_WHSE_MST

Line 773: SELECT MIN(whse_code) INTO X_fwhse_code FROM ic_whse_mst;

769: BEGIN
770: G_sy_all := fnd_profile.value('SY$ALL');
771:
772: IF G_fwhse_code IS NULL THEN
773: SELECT MIN(whse_code) INTO X_fwhse_code FROM ic_whse_mst;
774: ELSE
775: X_fwhse_code := G_fwhse_code;
776: END IF;
777: IF G_twhse_code IS NULL THEN

Line 778: SELECT MAX(whse_code) INTO X_twhse_code FROM ic_whse_mst;

774: ELSE
775: X_fwhse_code := G_fwhse_code;
776: END IF;
777: IF G_twhse_code IS NULL THEN
778: SELECT MAX(whse_code) INTO X_twhse_code FROM ic_whse_mst;
779: ELSE
780: X_twhse_code := G_twhse_code;
781: END IF;
782: --